datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
How to find out the database filenames?

Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to find the name of the server:

SELECT DBFileName = RIGHT(filename, CHARINDEX(CHAR(92), REVERSE(filename)) -1)

FROM master.sys.sysaltfiles

ORDER BY DBFileName

/*

DBFileName

Access2007.mdf

Access2007_log.ldf

AdventureWorks_Data.mdf

AdventureWorks_Log.ldf

AdventureWorks2008_Data.mdf

AdventureWorks2008_Log.ldf

.....

*/

 

Exam Prep 70-461
Exam 70-461