Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Suzhou, China
    Posts
    4

    Unanswered: SQL Server Locks

    Hi,

    Server: SQL Server 2000.

    I meet a strange things, when one table in my database locked,
    otheres tables(independent) can not be inserted.

    I view the locks from Locks/Object in EM,
    such as table A locked by some process,
    when I try to insert record into table B,
    the action will be hold until the lockes released.

    Thanks for help in advance!

  2. #2
    Join Date
    Dec 2003
    Location
    India
    Posts
    3
    This may be a problem because of some open Transaction/ lock escalation. Please let me know when and how the table A is locked.

    -Nilesh

Posting Permissions

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