suspect database

• Ricardo Strapasson

  Valued Member

  Points: 65

  More actions

  January 28, 2005 at 10:19 am

  #61652

  how i could find out a databse is suspected via transact sql commands  or system tables in sql server?

• hoo-t

  SSChampion

  Points: 12713

  More actions

  January 28, 2005 at 10:49 am

  #539588

  declare @db sysname

  set @db = 'pubs'

  if (select databaseproperty(@DB, 'isSuspect')) = '1'

   print '   *****  database is SUSPECT.  *****'

  else

   print '   database is not suspect.'

   

  -- Steve