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 JAVA2S\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>
Related examples in the same category