October 31, 2005 at 8:51 am
Step Error Description:Transaction (Process ID 199) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I am getting the above error from one of the error logs of our DTS packages.I have enabled the dbcc trace for the dead locks. I am not seeing any dead lock error in the error log, but when I see the error file of the DTS job its showing this error. Any Idea why this is happening.
with smiles
santhosh
October 31, 2005 at 9:42 am
You could have a look at this ms article: http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
Schedule this to run whenever the dts is going to be run and then look at the output file.
October 31, 2005 at 11:34 am
Which trace flags did you enable ? Did you enable, 1204, 1205 and 3605 ? If so, it would write the deadlock trace information to the error log for that instance. Also, please make sure that these traces are enabled on the instance to which those DTS packages connect to and run those tasks on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply