Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

EXEC sp_helpdb MyDatabase

3>  CREATE DATABASE MyDatabase 4> GO 1> EXEC sp_helpdb MyDatabase 2> GO name                                                                                                                             db_size       owner                                                                         dbid   created     status                                                                                             compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- --------------------------------------------------------- ----------------------------------------------------------------------- ------ ----------- ------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------- ------------------- MyDatabase                                                                                                                             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 name                                                                                                                             fileid filename                                                                                                                                                                                                      fil egroup                                                                                                                        size               maxsize            growth             usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --- ----------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- MyDatabase                                                                                                                            1 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Databas e_2.mdf                                                                                                                                                                                              PRI MARY                                                                                                                          1216 KB            Unlimited          1024 KB            data only MyDatabase_log                                                                                                                        2 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Databas e_2_log.LDF                                                                                                                                                                                          NUL L                                                                                                                             504 KB             2147483648 KB      10%                log only 1> DROP DATABASE MyDatabase 2> GO