TRY CATCH IN SQL SERVER 05

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

DBABC SSCarpal Tunnel Points: 4813 More actions · Answer 1

GSquared you rules......thanks man

thanks every one who tried to help me.

kend-631641 Grasshopper Points: 14 More actions · Answer 2

Just a note, I am running SSMS in SQL 2000 Compatibility Level (connected to SQL 2005) and Try/Catch works fine for me.

Noffer Ten Centuries Points: 1090 More actions · Answer 3

Been busy, just checked on this thread. Should have figured it was the db setting.

@usman.tanveer ... For some reason apparantly not every install has the same options...

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 4

I have faced the same problem in my SQL server.

Its because of the older version .. please install the latest patches and try it out.

BEGIN TRY

BEGIN TRANSACTION

COMMIT TRANSACTION

END TRY

BEGIN CATCH

ROLLBACK

END CATCH

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/