Post reply

Unlock table

  • August 27, 2008 at 9:00 am

    #211662

    Hello, within a stored procedure insert about 70.000 records to a table, but it is consulted and updated in other session in other stored procedures.

    My problem is: the stored procedure that insert is block this table.

  • August 27, 2008 at 9:21 am

    #863813

    This is by design so that data consistency can be maintained. There are some things you can probably to do alleviate some of that but not without certain risks being introduced. I would recommend that you read up on isolation levels and row versioning in Books Online a bit and post back here if you have specific questions.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply