Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Script to get the detail of every database or specific database

This script will show the detail of the every database of the sql server. It will show the space occupied by database.

sp_helpdb

It will show the all detail of the all databases in server.

If you want to see the specific database detail then you need to specify the database name also. query is given below:

sp_helpdb DatabaseName
Share this article   |    Print    |    Article read by 3203 times
Author:
Rohit kakria
I am software developer
Related Articles:
Related Interview Questions: