SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX | Journey to SQL Authority with Pinal Dave

While writing article about database collation, I came across sys.databases and DATABASEPROPERTYEX. It was very interesting to me that this two can tell user so much about database properties. Following are main database status: (Reference: BOL Database Status) ONLINE Database is available for access. OFFLINE Database is unavailable. RESTORING One or more files of the… Continue Reading...

Source: SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX | Journey to SQL Authority with Pinal Dave