Monday, May 09, 2005

List Available Databases

To List the datbases available in your SQL Server and show the path of .MDB file:

SELECT [name] [Database], [filename] [File Path]
FROM master..sysdatabases

0 Comments:

Post a Comment

<< Home