Monday, February 18, 2013

How to get the information of database in sqlserver

The sql server provides a procedure to get the information of desired data base .i;e SP_HELPDB.
In the below picture we can see the data and log information of the database.Here i have used query to get the data of existing database.
sp_helpdb 'Test krishna'

The result will show the size,administrator  and  status of the DB
 

Bel