Find All The Database Name in SQL SERVER

Get all the available database in SQL Server, using following command.

Following all the command will list all the database on SQL Server.


--In SQL Server 2008

--This is the Stored Procedure which will retrieve database name and size in kb and remark

Exec sp_databases

This stored procedure will retrieve more column then previous sp and return size in mb rather than kb.
And owner of db, created date, and status of the database like status, updatability, useraccessibility etc.

Exec sp_helpdb

and finally below 2 sps will retrieve detailed information about the database mostly in technical terms.

 Technically terms in the sense dbid,status, file path etc.

Select * From sys.databases

Select * From sys.sysdatabases

What Next

• Stumble it
• Digg this
• Save to Delicious
• Tweet it
• Subscribe

Related Posts