Script to get the detail of every database or specific database in sql server



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 3200 times
Author: Rohit kakria I am software developer	Related Articles: Insert Multiple records with single Insert stat... Create queries of database tables with its data... Insert Multiple records with single Insert stat... Turning Off and On Identity Column in SQL Serve... Related Interview Questions: Insert Multiple records with single Insert stat... Create queries of database tables with its data... Insert Multiple records with single Insert stat... Turning Off and On Identity Column in SQL Serve... What is difference between nchar & nvarchar... What is Stored procedure...