Home Forums SQL Server 2014 Administration - SQL Server 2014 I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE HELP ME HOW TO WRITE RE: I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE HELP ME HOW TO WRITE

  • kenn3th.w0ng (8/25/2014)


    Key point - proof of concept. We got to start somewhere.

    So what's the difference between SELECT COUNT(*) FROM someschema.sometable and SELECT @@SERVERNAME? Both will provide proof of concept except one doesn't have to worry about accessing a table in a database. And, you don't have to worry about trying to find a table common in multiple databases on multiple servers if that is your environment.