Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Transact-SQL Statements Allowed in Transactions

Transact-SQL Statements Allowed in Transactions

You can use all Transact-SQL statements in an explicit transaction, except for the following statements:

ALTER DATABASE

CREATE FULLTEXT INDEX

ALTER FULLTEXT CATALOG

DROP DATABASE

ALTER FULLTEXT INDEX

DROP FULLTEXT CATALOG

BACKUP

DROP FULLTEXT INDEX

CREATE DATABASE

RECONFIGURE

CREATE FULLTEXT CATALOG

RESTORE

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.

UPDATE STATISTICS can be used inside an explicit transaction. However, UPDATE STATISTICS commits independently of the enclosing transaction and cannot be rolled back.

Community Additions

ADD
Show:
© 2015 Microsoft