Viewing 14 posts - 31 through 44 (of 44 total)
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,...
June 3, 2005 at 9:43 am
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...
June 3, 2005 at 7:35 am
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...
June 1, 2005 at 5:15 am
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...
May 31, 2005 at 1:12 pm
I need to be able to do this on varchar, char and text columns.
May 31, 2005 at 8:37 am
But after having read the Kalen Delaney document "Hands-On SQL Server 2000 Troubleshooting : Locking and blocking" from NetImpress, it becomes clearer.
Except that Amazon will not allow this book to be sold...
May 31, 2005 at 4:52 am
Thanks for all the responses:
try BOL, search for "deadlocks, troubleshooting". This may help to trace where the deadlock is occuring.
Having read everything I could find regarding deadlocks in the BOL...
May 31, 2005 at 4:26 am
You'll get no arguement from me on that one I needed a quick fix, and one that would have minimal side effects otherwise...
April 27, 2005 at 6:59 am
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...
April 27, 2005 at 3:39 am
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...
April 13, 2005 at 6:07 am
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...
April 13, 2005 at 5:58 am
Viewing 14 posts - 31 through 44 (of 44 total)