Mega Code Archive

Database info message

1> CREATE DATABASE Database_2 2> GO 1> EXEC sp_helpdb Database_2 2> GO name db_size owner dbid created status compatibility_level ----------- Database_2 1.68 MB RNTSOFT\Joe 5 Oct 14 2006 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recov ery=SIMPLE, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 90 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ -------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------ -------------------------------------------------------------------------------------------------------------------------------- -------------- ---- ------------------ ------------------ --------- Database_2 1 c:\Program Files\Microsoft SQL Server\MSSQL. 1\MSSQL\DATA\Database_2.mdf PRIMARY 1216 KB Unlimited 1024 KB data only Database_2_log 2 c:\Program Files\Microsoft SQL Server\MSSQL. 1\MSSQL\DATA\Database_2_log.LDF NULL 504 KB 2147483648 KB 10% log only 1> DROP DATABASE Database_2 2> GO 1>