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.
See Also
Change History
|
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.
|