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.
Concepts
Transactions (Database Engine)
Explicit Transactions
Implicit Transactions
Help and Information
Getting SQL Server 2005 Assistance
|
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.
|