SQL Server 2008 error message from stored procedure
- by George2
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