A quick way to check and see all databases for your MS SQL server is to run the following command using the Query Analyzer on the Master database:
select name, filename from sysdatabases
A quick way to check and see all databases for your MS SQL server is to run the following command using the Query Analyzer on the Master database:
select name, filename from sysdatabases
Hi,
simple and straigt-forward query, that works just fine!!!!
thanks..