sp_IgnoreTableTransactions

Advantage SQL Engine

  Previous topic Next topic  

Sets the table’s transaction-free table state.

 

Syntax

sp_IgnoreTableTransactions( 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_IgnoreTableTransactions 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

system.tables

AdsSetTableTransactionFree

Transaction-Free Tables

sp_ModifyTableProperty

 

Examples

 

EXECUTE PROCEDURE sp_IgnoreTableTransactions( 'customers' );

 

EXECUTE PROCEDURE sp_IgnoreTableTransactions( '\\server\share\log_table', false );