Friday, March 23, 2012

Find what procedure was execd

Hello

I need to find out what stored procedure was executed when I click on
a button in a third party application, is there a way to find this
information out in some sort of log?

Some kind of profiling to see what procedure was executed and with
what parameters.

Kind Regards

Matt
www.fruitsalad.org"Matt" <matt@.fruitsalad.org> wrote in message
news:b609190f.0312130930.377f4d7c@.posting.google.c om...
> Hello
> I need to find out what stored procedure was executed when I click on
> a button in a third party application, is there a way to find this
> information out in some sort of log?
> Some kind of profiling to see what procedure was executed and with
> what parameters.
> Kind Regards
> Matt
> www.fruitsalad.org

You can use SQL Profiler to trace all the SQL sent to the server - see Books
Online for details.

Simon

No comments:

Post a Comment