Results 1 to 3 of 3

Thread: table lock

  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: table lock

    i have a SP that updates a table for about 2hours. My question is, is it possible to unlock this table so that other SPs or SSIS packages can update/innsert into the same table i am updating. thanks

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Consider using a table locking hint.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I would try to shorten the update. Why does it take 2 hours? Can the update be broken down into smaller (presumably faster) batches? Using a read uncommitted isolation level may set you up for a world of inconsistent data hurt.

Posting Permissions

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