Yes, I understand that. But he also wants to commit the transaction. So
although the 'nested tran' solution will hold the locks, it WON'T commit the
SQL Server MVP
"JXStern" <net> wrote in message
> Kalen, he doesn't want to release the locks, he wants to HOLD them!