SQLException deadlocked: does the exception contains the query text executed somewhere?

The SQLException "was deadlocked on lock resources with another process and has been chosen as the deadlock victim" is quite common ;-)

Does the exception contains the query text executed 开发者_JAVA技巧somewhere ? Is it possible to obtain ?

Thks

Yes, but not in your exception. You SHOULD KNOW WHAT YOU DID - and the exception just tells you that YOU Deadlocked. You should know what SQL youwere executing at this moment.

For the rest, use the query profiler and other information you obtain from teh server (check http://support.microsoft.com/kb/832524 for some tips, or http://msdn.microsoft.com/en-us/library/aa937573(v=SQL.80).aspx to find out what OTHER scripts you deadlock with. THis is, though, for very obbvious security reasons, something onl adins do.