On 2006-03-02, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> TRUNCATE is another command that takes an access exclusive lock. > > The whole SP takes about 10 seconds to run total. The TRUNCATE command > only takes less than a second. However, the access exclusive lock is > held throughout the entire SP, not just during the execution of the > TRUNCATE command. Shouldn't TRUNCATE be releasing the lock as soon as > it finishes?
No, locks are always held until the end of the transaction. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
