Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Query to get only executed SP from DB

Author  Topic 

shaggy
Posting Yak Master

248 Posts

Posted - 2012-01-20 : 00:14:48
I want to get only the executed SP from DB is there any query to get this.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-01-20 : 06:41:25
Didn't quite understand what you meant by "getting the executed SP". You can use SQL Profiler to look at the stored procedures that get executed. You can also use DBCC INPUTBUFFER to see what was sent to the server.
Go to Top of Page
   

- Advertisement -