Testing for Online/Suspect Mode?

Question

Is there a method or system call to find out if a particular database is in Suspect Mode from TSql?

 

Thanks,

Jeff

Answer 1

You can do one of the below:

 

1. DATABASEPROPERTYEX metadata function in SQL Server 2000/2005

 

http://msdn2.microsoft.com/en-us/library/ms186823.aspx

 

2. sys.databases catalog view in SQL Server 2005

 

http://msdn2.microsoft.com/en-us/library/ms186823.aspx

 

3. sp_helpdb in any version of SQL Server

 

http://msdn2.microsoft.com/en-gb/library/ms178568.aspx

Answer 2

Umachandar

    Thanks!  DATABASEPROPERTYEX worked like a champ! 

 

Jeff