SQL Server 2008 error message from stored procedure
Posted
by George2
on Stack Overflow
See other posts from Stack Overflow
or by George2
Published on 2010-06-05T09:00:33Z
Indexed on
2010/06/05
10:12 UTC
Read the original article
Hit count: 170
sql-server-2008
|logging
Hello everyone,
I am using SQL Server 2008 Enterprise. When we met with such error message from stored 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 advance,
George
© Stack Overflow or respective owner