TRAN_ABORT gone?

[NiTiN]

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/art...&seqNum=8&rl=1

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

[Dan Guzman]

Did Microsoft decide to do away with the

TRAN_ABORT keyword?

Yes. Many changes were made during the development cycle.

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

The latest Books Online (plus mskb articles) is the authoritative reference.
Articles written based on pre-release software may be interesting from a
historical perspective but might not reflect reality.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"NiTiN" <em***********@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...

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/art...&seqNum=8&rl=1

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

[Alan Brewer [MSFT]]

That article was written in 2004, and therefore reflects SQL Server 2005
Beta 1. TRAN_ABORT was gone by Beta 2.

The current Books Online topics reflect the functionality that shipped in
the final release or was added in Service Pack 1.

--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/pro...ads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.