SQL Server Alerts - WITH LOGGING

  • I've just started playing around with SQL server alerts and ran into something odd.

    It seems that you can specify an alert to place an entry into the Windows server event log which automatically places an entry into the sql server error log.

    However, certain system alerts seem to have the ability to appear in the SQL Server error log without placing an entry in the Windows Server event log.

    How'dTheyDoThat?

    Also, if I have the alert kick off a job does it pass any data to the job?


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • This was removed by the editor as SPAM

  • Check BOL about severity levels. Severity level 0 for sure only writes to the SQL Error Log.



    Shamless self promotion - read my blog http://sirsql.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply