Posted by NiTiN on 08/09/06 12:00

Hi!

I've been trying out SQL Server 2005's new Try-Catch exception handling
and I tried using the following form:

SET XACT_ABORT ON
BEGIN TRY
END TRY
BEGIN CATCH TRAN_ABORT
END CATCH

However, I get a syntax error on TRAN_ABORT.... removing it gives me
the expected output. Did Microsoft decide to do away with the
TRAN_ABORT keyword?

The syntax above (with the TRAN_ABORT) can be found at:
http://www.informit.com/articles/article.asp?p=327394&seqNum=8&rl=1

I did find some other articles (including MS SQL Server 2005 BOL) that
entirely left out the TRAN_ABORT keyword.

• Next in forum: Re: Using Union and Join in a single view
• Prev in forum: thank you
• Thread view: TRAN_ABORT gone?

[Reply to this message]