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

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_helpdb

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