|
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
.....
*/
|
