I have an Openfire database that was originally installed on sql 2000 that periodically just goes haywire and lands itself in SUSPECT status, PENDING RECOVERY. I have a series of commands I run that resolve the problem. My issue now, is we've moved this to a 2005 server and one of the commands isn't working. This is the command I used to use:
That command was apparently retired with sql2000. How do I accomplish the same thing in sql2005?