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!
|