Thursday, January 11, 2007 9:31 PM
Is there a method or system call to find out if a particular database is in Suspect Mode from TSql?
Thursday, January 11, 2007 10:20 PMYou can do one of the below:1. DATABASEPROPERTYEX metadata function in SQL Server 2000/20052. sys.databases catalog view in SQL Server 20053. sp_helpdb in any version of SQL Server
Thursday, January 11, 2007 11:09 PM
Thanks! DATABASEPROPERTYEX worked like a champ!