Hello everyone,
When we met with such error message from store procedure,
Message 1205, Level 13, State 52, the process Pr_FooV2, Line 9
Services (Process ID 111) and another process is deadlock in the lock | communication buffer resources, and has been chosen as the deadlock victim. Rerun the transaction.
I am wondering whether such messages are stored in log files? I searched log folder of my SQL Server 2008 installation root (in my environment, it is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log), but can not find such files.
thanks in avdance,
George