Can you use a try catch in the outewr proc and get the error number such as in this page? https://technet.microsoft.com/en-us/library/aa175791(v=sql.80).aspx ( *SQL Essentials: Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005)*
regards, Preet, in Auckland NZ On 1 February 2018 at 14:42, David Burstin <david.burs...@gmail.com> wrote: > Hi folks, > > Hope everyone is having a great day and enjoyed the super blue blood moon > last night. > > Quick question: > > Given a stored procedure "OuterProc" that calls another stored procedure > internally "InnerProc" > When I call "OuterProc" from C# using a connection with a started > transaction, and "InnerProc" becomes a deadlock victim > Is there a way that I can identify in my C# code that "InnerProc" was the > deadlock victim, given that my C# code only knows about "OuterProc"? > > Cheers > Dave >
