Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.