Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

EXEC 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