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
7-mode autotask backup blog bookmark cacti camera cisco cli cluster ConfigMgr connectwise Datacenter dfm dfs fun gx home isy logicmonitor netapp network oncommand ontap opsmgr photos powershell reporting san SCOM script sme sms2003 snapshots soap srm ssd ssh tasks toy uptimedevices vmware vmx vol work
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
1 Comment
Arun Prasad
16 years agoHi,
simple and straigt-forward query, that works just fine!!!!
thanks..