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 2:56 am

    #1109824

    Dale Turley (1/28/2010)

    First off - great article and a really handy stored procedure..

    When i executed the sp i got this error message

    Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72

    An INSERT EXEC statement cannot be nested.

    Msg 242, Level 16, State 3, Procedure uspEmailSQLServerHealth, Line 126

    The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

    It did send me an email though so all's good.

    First off, great article. Thank you for sharing.

    However I have encoutered the same issue as above and not yet resolved. (SQL 2005 standard edition)

    Also quick correction on your example, just incase anyone doesnt click that

    exec EmailSQLServerHealth '10.10.10.10', 'MYProject', 'myself@mycompany.com', 'TestMailProfile', 'My Self'

    should be

    exec uspEmailSQLServerHealth '10.10.10.10', 'MYProject', 'myself@mycompany.com', 'TestMailProfile', 'My Self'

    Thanks again 😉