Transact-SQL Statements Allowed in Transactions
You can use all Transact-SQL statements in an explicit transaction, except for the following statements:
ALTER DATABASE |
DROP DATABASE |
ALTER FULLTEXT CATALOG |
DROP FULLTEXT CATALOG |
ALTER FULLTEXT INDEX |
DROP FULLTEXT INDEX |
BACKUP |
RECONFIGURE |
CREATE DATABASE |
RESTORE |
CREATE FULLTEXT CATALOG |
UPDATE STATISTICS |
CREATE FULLTEXT INDEX |
You also cannot use the following:
Full-text system stored procedures in an explicit transaction. For more information, see Full-Text Search Stored Procedures (Transact-SQL).
sp_dboption to set database options or use any system procedures that modify the master database inside explicit or implicit transactions.