Home Forums SQL Server 7,2000 Administration require db monitor script for sql 2000 RE: require db monitor script for sql 2000

  • April 16, 2013 at 9:44 am

    #1606882

    hows this as a starter?

    select * from master..sysdatabases where databasepropertyex([name], 'status') != 'online'

    ---------------------------------------------------------------------