Query sys.databases (use sysdatabases and the DATABASEPROPERTYEX function on SQL 2000 and below)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability