20/10/2010 Obtaining Database Information Using sp_helpdb
Following on from my previous post on sp_help, the sp_helpdb stored procedure provides useful information at the database level.
Running sp_helpdb without specifying a database provides an overview of all databases within the instance.
The query returns the following information:-
name
database size
owner
database id
creation date
database status
compatibility level
By specifying a database,
sp_helpdb 'AdventureWorks'
additional information is provided on that databases data files and log files:-
Advertisements
Tags: database, sp_helpdb, SQL, SQL Server, Stored Procedure, T-SQL
- Leave a comment
- Posted under Stored Procedure
Leave a Reply