Hi Gail,

Here's the XML file (if I've managed to attach it correctly).

Andy

Hi Gail,

Thanks for your reply, which was very illuminating: it certainly hadn't occurred to us that indexes could be involved in deadlocks. However, the scenario you describe doesn't apply...

I forgot to send the deadlock graph, so here it is:

<?xml version="1.0" encoding="utf-16" ?>

- <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">

- <Header>

<TraceProvider name="Microsoft SQL Server" MajorVersion="10" MinorVersion="0" BuildNumber="2531" />

...

Hi Everybody,

Thanks for your replies. I realise there are autocommit transactions, but since they are each one statement long, how can there be deadlocks unless one statement manages to...