Results 1 to 3 of 3

Thread: locks

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: locks

    Some of my tables Were locked IN IS Mode.What does it mean?
    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That depends on what you saw and where you saw it. Different tools report things differently. Can you post some more details?

    -PatP

  3. #3
    Join Date
    Jul 2004
    Posts
    60
    assuming you're getting that info using the stock tools (Enterprise Mangler or isqlw, etc) what that is trying to tell you is that a current transaction intends on placing a shared lock on pages/rows allocated to the table you see the IS lock on.
    it's a way for sql server to keep an exclusive lock from coming by and interrupting/blocking the current transaction.
    nothing to worry about, IMHO.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •