How can you as a developer see what stored procedures an application is accessing on a sql server 2005 database at run time.
I'm after something along the lines of sql monitor that used to ship with Delphi, which maybe some of you have heard of...
Basically, my client wants to grant execute rights to only those stored procedures being used. Trouble is, I dont have the front end application source code to determine whats being called but there must an easy way of doing this, there must be some utility in SSMS that does this. I dont want to trouble our DBAs with this either.
Also how would be able to view any dynamic sql being generated by the app?
Thanks alot, I'm sure its an easy one for you brainiacs to answer.