Post reply

how to trap <= 10 seviarity llevel error.

  • July 26, 2015 at 2:08 am

    #319259

    hi,

    I want to log <=10 severity level error, for all database and for single stored proc.

    please tel me how it can be done.

    (with out using profiler)

    yours sincerely

  • July 26, 2015 at 4:27 am

    #1814996

    rajemessage 14195 (7/26/2015)

    hi,

    I want to log <=10 severity level error, for all database and for single stored proc.

    please tel me how it can be done.

    (with out using profiler)

    yours sincerely

    You can use extended events, changes are you will quite a large output.

    😎

    Her is an article on this: Trapping SQL Server Errors with Extended Events by Davide Mauri

  • July 26, 2015 at 5:31 am

    #1814997

    You'll need profiler or preferably extended events. You could probably do it with agent alerts as well, but I wouldn't recommend it. The volume of email will be spectacular.

    Messages with severity 10 or below are informational messages, not errors and there are a lot of them.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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