Thursday, November 4, 2010

SQL Server : Find File Location for All Database

Here is the quick script I use find file location for all the database in my server instance.


SELECT Name, FileName FROM sysdatabases


if you have any other way to find please share!!!  

No comments:

Post a Comment