Thanks Chris... that is very helpful... Now I know they are possible

I still can't see how I would be getting that situation, because I don't use transactions on the reads,...

I investigated the query further that was getting killed by the deadlock, and this query only uses the following locks:

S

IS

Sch-S

Now I thought that a deadlock occured when 2 proceses end...

Hi Carl,

Thanks for the info, I managed to get hold of a copy of the book and read it this morning.

Can you say a bit more about what was causing...

DOH! Of course that collation works that way...I even pointed it out to someone the other day

Nice, very clean solution. I knew there...

Latin1_General_CI_AS - thanks

I need to be able to do this on varchar, char and text columns.

Except that Amazon will not allow this book to be sold...

Thanks for all the responses:

Having read everything I could find regarding deadlocks in the BOL...

You'll get no arguement from me on that one I needed a quick fix, and one that would have minimal side effects otherwise...

Can't say I've ever used Access... cut my teeth on SQL Server

I guess you know that you can't have more than one identity...

Thanks - I appreciate it.

Sorry - I didn't have time to understand the full details of what you need to accomplish - so if this is off the mark please ignore.

Anyway if you can...

OK - thats handy.

Do you know of anything better than sp_lock to determine locking info?

We have a document management system with the documents stored in the DB. Documents are based...

Right - thanks