April 3, 2014 at 1:14 pm
Hi,
Does SQL Server keeps a history of execution of stored procedures, like who executed and when? If yes, how do I access that information?
Thanks.
April 3, 2014 at 1:32 pm
rehman-615909 (4/3/2014)
Hi,Does SQL Server keeps a history of execution of stored procedures, like who executed and when? If yes, how do I access that information?
Thanks.
No it does not record that information. You would have to add that level of logging yourself.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 3, 2014 at 1:35 pm
Thanks Jeff.
April 3, 2014 at 2:27 pm
rehman-615909 (4/3/2014)
Thanks Jeff.
Actually, that was Sean.
🙂
April 3, 2014 at 2:44 pm
Oops, sorry Sean.
April 3, 2014 at 2:53 pm
rehman-615909 (4/3/2014)
Oops, sorry Sean.
No problem. I don't mind letting Jeff have the credit...especially if I am wrong. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 3, 2014 at 5:06 pm
But you can see an aggregation of the queries currently in cache in sys.dm_exec_query_stats. It shows execution times, counts, other stuff like that, but not who did the executing or parameter values, that type of thing.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply