Post reply

Trance Profiler

  • August 3, 2011 at 3:08 am

    #242543

    Hi Team,

    i m Tracing sql Profiler in 2008

    In Events for All Errors

    Failed Loings Which option i have to select please help me

    Thanks in advance..

  • August 3, 2011 at 3:15 am

    #1362877

    I think you're looking for the Audit Login Failed event, under Security.

    John

  • August 3, 2011 at 3:18 am

    #1362878

    Hi John

    You are correct i have select it

    and for ALL ERRORS Which option i have to check.

    Tx

  • August 3, 2011 at 3:32 am

    #1362881

    I don't understand your question. What is ALL ERRORS? If you want to capture failed logins, do as I suggested. Are you saying you need to capture something else as well?

    John

  • August 3, 2011 at 3:44 am

    #1362885

    Hi John

    each Error and User login failure and how many times it occurred for this only

    i have to select all errors..but in sql profiler i should not find out all errors option

    could any body please suggest me for tracing.

    on ALL Errors which option.

    Tx

  • August 3, 2011 at 3:49 am

    #1362888

    You're probably going to have to do a bit of trial and error. Expand the Errors and Warnings category, and hover your cursor over each event for a description. If it sounds like something you need to capture, tick the box next to it.

    I think you're maybe looking for an event that captures all errors, but I don't think that exists.

    John

  • August 3, 2011 at 4:04 am

    #1362894

    Hi John,

    Yes your correct in the events

    i have select Error Log and Login failed option it is correct right.

    tx

Viewing 7 posts - 1 through 6 (of 6 total)

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