Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    63

    Unanswered: Detecting a suspect database...

    Howdy.

    Hey, I am writing a proc that will monitor database vitals. does anyone know how to tell if a database is in suspect mode from query analyzer? I imagine you should be able to tell from the status column in sysdatabases, but I cant seem to figure it out.

    TIA

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138

  3. #3
    Join Date
    Jul 2003
    Posts
    7
    Type following on the SQL Query Analyser

    USE <database_name>
    SELECT DATABASEPROPERTY('<database_name>', 'IsSuspect')

    Check result:
    1 = TRUE
    0 = FALSE
    NULL = Invalid input

    Hope this helps!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •