Forum Replies Created

Viewing 14 posts - 31 through 44 (of 44 total)

  • RE: Deadlocks with read

    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,...

  • RE: Deadlocks with read

    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...

  • RE: Deadlocks with read

    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...

  • RE: Finding Characters Patterns

    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...

  • RE: Finding Characters Patterns

    Latin1_General_CI_AS - thanks

  • RE: Finding Characters Patterns

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

  • RE: Deadlocks with read

    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...

  • RE: Deadlocks with read

    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...

  • RE: Table Locking

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

  • RE: Table Locking

    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...

  • RE: Table Locking

    Thanks - I appreciate it.

  • RE: to cursor or not to cursor

    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...

  • RE: UPDATETEXT with Locking

    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...

  • RE: Column order in Enterprise Manager

    Right - thanks

Viewing 14 posts - 31 through 44 (of 44 total)