SQL Server/T-SQL/Database/Database Info

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