Transact-SQL Statements Allowed in Transactions
SQL Server 2008
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.
