Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ritesh Medhe Automating SQL Server Health Check (SQL Server 2005) RE: Automating SQL Server Health Check (SQL Server 2005)

  • January 28, 2010 at 12:51 am

    #1109782

    Hello,

    thanks for the promising looking script! But at least for me this script is not working and fails with error..even I have just copy&paste the the script ..Did I something wrong?

    Errors I've got:

    Msg 137, Level 15, State 1, Procedure uspEmailSQLServerHealth, Line 146

    Must declare the scalar variable "@OriServer".

    Msg 137, Level 15, State 1, Procedure uspEmailSQLServerHealth, Line 147

    Must declare the scalar variable "@strSubject".

    Msg 137, Level 15, State 2, Procedure uspEmailSQLServerHealth, Line 167

    Must declare the scalar variable "@OriServer".

    Msg 137, Level 15, State 2, Procedure uspEmailSQLServerHealth, Line 228

    Must declare the scalar variable "@OriServer".

    Msg 102, Level 15, State 1, Procedure uspEmailSQLServerHealth, Line 261

    Incorrect syntax near 'X'.

    Msg 137, Level 15, State 2, Procedure uspEmailSQLServerHealth, Line 382

    Must declare the scalar variable "@startdate".

    Msg 137, Level 15, State 2, Procedure uspEmailSQLServerHealth, Line 430

    Must declare the scalar variable "@owner".

    Msg 137, Level 15, State 2, Procedure uspEmailSQLServerHealth, Line 440

    Must declare the scalar variable "@strSubject".

    Thanks in advance!