EXEC sp_helpdb : sp_helpdb « System Functions « SQL Server / T-SQL Tutorial






3> EXEC sp_helpdb
name                                                                                                                             db_size       owner
                                                                        dbid   created     status


                                                                                            compatibility_level
-------------------------------------------------------------------------------------------------------------------------------- ------------- ---------------------------------------------------------
----------------------------------------------------------------------- ------ ----------- -------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------- -------------------
ClubRoster                                                                                                                             1.68 MB J\Administrator
                                                                             5 Aug 17 2008 Status=SUSPECT, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, IsAutoClose, I
sAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled

                                                                                                             90
master                                                                                                                                 4.75 MB sa
                                                                             1 Apr  8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics

                                                                                                             90
model                                                                                                                                  1.69 MB sa
                                                                             3 Apr  8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics

                                                                                                             90
msdb                                                                                                                                   4.94 MB sa
                                                                             4 Oct 14 2005 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled

                                                                                                             90
ProSSEAppsCh07                                                                                                                         1.68 MB J\Administrator
                                                                             6 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled

                                                                                                             90
tempdb                                                                                                                                 2.50 MB sa
                                                                             2 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L
atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics








25.43.sp_helpdb
25.43.1.EXEC sp_helpdb MyDatabase
25.43.2.EXEC sp_helpdb