November 29, 2012 at 9:10 am
I need to find any failed EXECUTE attempt in the past two days on a particular Stored Procedure using any Login, from the application server side.
How can I achieve this?
SueTons.
Regards,
SQLisAwe5oMe.
November 29, 2012 at 9:20 am
SQLCrazyCertified (11/29/2012)
I need to find any failed EXECUTE attempt in the past two days on a particular Stored Procedure using any Login, from the application server side.How can I achieve this?
SueTons.
Unless you have trace or some auditing in place I am not sure you can find this. Not sure what you are looking for but without some custom auditing you are not going to find the user info or parameter list or any kind of details like that.
_______________________________________________________________
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/
November 29, 2012 at 10:04 am
You would already have to have in place auditing. Capturing RPC Starting from Extended Events or Trace Events and then comparing that to RPC Complete will let you know when you have a failed execution. But, that only gets the failure if it's something that occurred within the query. If the failures are because of access or something else where the procedure doesn't even fire, then you're out of luck.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply