Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2005
 Transact-SQL Statements Allowed in ...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
Transact-SQL Statements Allowed in Transactions

Updated: 14 April 2006

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.

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.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker