Listing 1: Code That Enterprise Manager Sends to SQL Server When Populating the Database List
SELECT name, DATABASEPROPERTY(name, N'IsDetached'),
     (CASE WHEN DATABASEPROPERTY(name, N'IsShutdown') IS NULL THEN -1
          ELSE DATABASEPROPERTY(name, N'IsShutdown') END),
     DATABASEPROPERTY(name, N'IsSuspect'), DATABASEPROPERTY(name, N'IsOffline'),
     DATABASEPROPERTY(name, N'IsInLoad'),
     (CASE WHEN DATABASEPROPERTY(name, N'IsInRecovery') IS NULL THEN -1
          ELSE DATABASEPROPERTY(name, N'IsInRecovery') END),
     (CASE WHEN DATABASEPROPERTY(name, N'IsNotRecovered') IS NULL THEN -1
           ELSE DATABASEPROPERTY(name, N'IsNotRecovered') END),
     DATABASEPROPERTY(name, N'IsEmergencyMode'),
     DATABASEPROPERTY(name, N'IsInStandBy'),
     has_dbaccess(name),
     status, category, status2
FROM master.dbo.sysdatabases