1 Version 4.0 -- 1/15/89 sp_helpdb
______________________________________________________________________
NAME: sp_helpdb
FUNCTION:
Reports information about a database or about all databases.
SYNTAX:
sp_helpdb [dbname]
EXAMPLES:
1) sp_helpdb pubs
Displays information about the pubs database:
sp_helpdb Version 4.0 -- 1/15/89 2
______________________________________________________________________
name db_size owner dbid created status
------ -------- -------- ------ ----------- ----------------
pubs 2 MB sa 4 Sep 15 1987 no options set
(1 row affected)
device size usage
------------------------------- ------------- --------------------
master 2 MB data and log
(1 row affected)
2) sp_helpdb
Displays information about all the databases on SQL Server.
3 Version 4.0 -- 1/15/89 sp_helpdb
______________________________________________________________________
PARAMETERS:
dbname - is the name of the database about which information is
to be displayed. Omitting this optional parameter results in
a report about all databases.
COMMENTS:
o Executing sp_helpdb reports on the specified database when
dbname is given, or on all databases in master.dbo.sysdatabases
when no parameter is supplied.
MESSAGES:
The specified database doesn't exist on SQL Server. Run the pro-
cedure without the dbname parameter to see a list of all the
databases.
sp_helpdb Version 4.0 -- 1/15/89 4
______________________________________________________________________
PERMISSIONS:
Execute permission to public.
TABLES USED:
master.dbo.spt_values, master.dbo.sysdatabases,
master.dbo.syslogins, master.dbo.sysusages,
master.dbo.sysdevices, #spdbdesc
SEE ALSO:
sp_configure, sp_dboption, sp_renamedb, ALTER DATABASE, CREATE
DATABASE