Posted by Alex Kuznetsov on 06/22/07 13:43

On Jun 22, 8:17 am, Altman <balt...@easy-automation.com> wrote:
> I have a customer using our program with SQL server and is
> occasionally getting a "Transaction (process ID xxxxx) was deadlocked
> on lock resources with another process and has been chosen as the
> deadlock victim." From what they are telling me, there shouldn't be
> any deadlock happening as they say this happens when they invoicing in
> a different program that is accessing a different database. Also the
> error is happening on an SQL Select from a view and this select is
> then showing data in an HTML table for the user. I don't think this
> view should need to lock anything, I just want to read the data. Is
> there anything I can do to fix this?

Read "Analyzing Deadlocks with SQL Server Profiler" in BOL.

http://sqlserver-tips.blogspot.com/

[Back to original message]