>>
>>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.

Hi Kevin,

OK, thank you. I was a VFP developer and now a Axapta developer so I never touched SQL in directly so much, but however I should be aware for this... :)