>
>I think you don't need any parameters like holdlock or rowlock between begin and end tran. But you have to use begin/end trans carefully. You may cause deadlock.

Hi, Metin, not to be picky, but in SQL Server it's "BEGIN TRANS/COMMIT TRANS (or ROLLBACK TRANS)". "BEGIN/END" are simply to delimit blocks of code.