|
sp_IgnoreTransactions Advantage SQL Engine |
|
|
|
sp_IgnoreTransactions Advantage SQL Engine |
|
|
Sets the table’s transaction-free table state.
Syntax
sp_IgnoreTransactions( TableName, CHARACTER, 515, [ IgnoreTransactions, LOGICAL] )
Parameters
TableName (I) |
The name of the table to configure. For free tables, this must be a relative path to the table on the server or a fully qualified UNC path. For database tables, this should be the name of the table in the database.
|
IgnoreTransactions (I) |
Optional parameter indicating the desired transaction-free table state. If not specified, the table is converted into a transaction-free table.
|
Output
None
Remarks
The sp_IgnoreTransactions system procedure is used to configure a table as a transaction-free table (when IgnoreTransactions is true, or omitted) or restore the table to its default state (when IgnoreTransations is False).
This system procedure requires exclusive access to the table.
See Also
Examples
EXECUTE PROCEDURE sp_IgnoreTransactions( 'customers' );
EXECUTE PROCEDURE sp_IgnoreTransactions( '\\server\share\log_table', false );