finding Database properties using T-SQL

[iluvsushi79]

Hi,

Does anyone know how I can find, using T-SQL in SQL server 2000/2005, database property information (such as path of where each database files are residing, recovery mode, filegrowth...etc?)
I need to create a report of this and don't know where to go from here.

Thanks in advance!

 

[yelworcm]

The DATABASEPROPERTYEX function will get you some of the information (recovery mode, readonly/write status, etc.). File locations are kept in the sysfiles table in SQL 2000, and sys.database_files table in SQL 2K5.