Monday, December 3, 2007

How to find a list of database available in the system

How to find a list of database available in the system

Step 1

To find a list of database attached to MSSQL Server, this will normally be shown when you are in MSSQL Server Enterprise Manager.

Step 2

But to have MSSQL Server SQL analyzer, you can find a list of attached database in your system by :

EXEC sp_helpdb

No comments: