Post reply

Tracing failed SP call

  • May 15, 2013 at 6:21 pm

    #277901

    Does anyone know if its possible to trace failed SP calls through Profiler? For example, if you call an SP without a required param, it red inks but nothing shows up in the trace to identify the failed proc call.

    This would be helpful when debugging errors in a binaries data access.

    Thanks in advance.

  • May 15, 2013 at 8:18 pm

    #1615594

    Hi,

    I think SP:CacheMiss might help you. It is under Stored Procedures in the Events Selection tab. According to msdn this will : "The SP:CacheMiss event class indicates that the procedure is not found in the cache."

    It's probably not built for your purpose but I think it might just work!

    Regards,

    Bevan Keighley

  • May 16, 2013 at 7:41 am

    #1615788

    Thanks! Just gave it a shot and I think it'll do.

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

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