SET XACT_ABORT ON

Do something here
GO

Do extra stuff
GO

SET XACT_ABORT OFF

BEGIN TRAN

USE tempdb
GO

SELECT 'foo' AS [HAHA] INTO bar
Go

USE model
GO

SELECT 'woo' AS [HOHO] INTO sho
GO

SELECT * FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE [TABLE_NAME] = 'bar'
SELECT * FROM model.INFORMATION_SCHEMA.TABLES WHERE [TABLE_NAME] = 'sho'
GO

ROLLBACK

SELECT * FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE [TABLE_NAME] = 'bar'
SELECT * FROM model.INFORMATION_SCHEMA.TABLES WHERE [TABLE_NAME] = 'sho'

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

quote:

---

Originally posted by sql-lover

Hi,

An easy one. I just want to confirm.

I know GO is a Microsoft stuff. But can I use it inside a transaction, assuming I'm running my T-SQL snippet from Management Studio?

I understand it should be avoided if it's being called from a programming language code, as GO is not pure SQL. But I am going to run the script via Management Studio.

Here's a pseudo code with what I'm saying

SET XACT_ABORT ON

Do something here
GO

Do extra stuff
GO

SET XACT_ABORT OFF

Or, will it create problems in case of a failure and a rollback is needed?

Thanks,

---