how to get last few executed Stored procedures along with the values of the parameters

Question

4.00/5 (1 vote)

See more:

SQL-Server-2008

Hi all,

Does anybody know how can I find the last few executed Stored procedures along with the values of the parameters.
It is just like what we see in the Sql Profiler but I dont have Sql Profiler on my machine due to certain constraints.
I have seen a lot of examples on the net but none shows the SP with its parameter values.

Any help would be much appreciated.

Regards ,
Gopal

Posted 1-Feb-12 22:29pm

gopalgupta

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Herman<T>.Instance · Answer 1 · 2012-02-01T22:45:00

Solution 1

it is a system function called fn_get_sql. See here[^].
More in depth here[^]

Posted 1-Feb-12 22:45pm

Herman<T>.Instance

Updated 1-Feb-12 22:46pm

v2

Rajesh Anuhya · Answer 2 · 2012-02-01T22:48:00

Solution 2

Try this Query

SQL

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC

Thanks
--RA

Posted 1-Feb-12 22:48pm

Rajesh Anuhya

Comments

gopalgupta 2-Feb-12 5:24am

this does not return the parameter values that were passed while executing the sp .... it just returns the create sp statement

Rajesh Anuhya 2-Feb-12 5:28am

Have you tried this ???

gopalgupta 2-Feb-12 6:06am

yes ... i already had tried the same query

how to get last few executed Stored procedures along with the values of the parameters

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to get last few executed Stored procedures along with the values of the parameters

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us