|
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
|