var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
Consider using a table locking hint.
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.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors