database in suspect mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tulip - 19 Mar 2008 16:30 GMT

If i need to query the system databases to find out witch database is in
suspect mode, what would be the tables and the field of the value? thanks

Reply to this Message

Uri Dimant - 19 Mar 2008 16:35 GMT

Take a look at DATABASEPROPERTY function in the BOL

> If i need to query the system databases to find out witch database is in
> suspect mode, what would be the tables and the field of the value? thanks

Reply to this Message

Linchi Shea - 19 Mar 2008 20:18 GMT

select * from master..sysdatabases
where status & 256 = 256

Linchi

> If i need to query the system databases to find out witch database is in
> suspect mode, what would be the tables and the field of the value? thanks

Reply to this Message

tulip - 20 Mar 2008 22:08 GMT

I use the query it return 0,i check the status of the database, it is 16, but
on Enterprise manger, i saw that besides the database name it specified
(Suspect), also i use SELECT DATABASEPROPERTY('dbxxx', 'IsSuspect') it return
false. So why exactly it showes suspect? thanks.

> select * from master..sysdatabases
> where status & 256 = 256
[quoted text clipped - 3 lines]
> > If i need to query the system databases to find out witch database is in
> > suspect mode, what would be the tables and the field of the value? thanks

Reply to this Message