This topic has not yet been rated - Rate this topic

Transact-SQL Statements Allowed in Transactions

SQL Server 2005

Updated: 14 April 2006

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

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.

Release	History
14 April 2006	New content: Added information about full-text Data Definition Language (DDL) statements and system stored procedures. Changed content: Clarified information about explicit and implicit transactions.

Release

History

14 April 2006

New content:

Added information about full-text Data Definition Language (DDL) statements and system stored procedures.

Changed content:

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions