Read and implement the sample code listed in the following links.
BEGIN TRANSACTION ...http://technet.microsoft.com/en-us/library/ms188929.aspx
Within the TRY block
T-SQL block...http://technet.microsoft.com/en-us/library/ms175976(SQL.90).aspx
Within the CATCH block
ROLLBACK TRANSACTION ....http://technet.microsoft.com/en-us/library/ms181299.aspx
No error
COMMIT TRANSACTION .... http://technet.microsoft.com/en-us/library/ms190295.aspx
If you have additional questions after following / reading the references come back and post the problem following the recommended method as discussed in the first link in my signature block
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]