AllowQueuedTransactions Property
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The AllowQueuedTransactions property specifies whether a publication allows queued-transaction updates to be performed at the Subscriber.
Sintassi
object.AllowQueuedTransactions [=value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write if a SQL Distributed Management Objects (SQL-DMO) object is used to create a replication component. Read-only if the object references an existing component.
Prototype (C/C++)
HRESULT GetAllowQueuedTransactions(LPBOOL pRetVal);
HRESULT SetAllowQueuedTransactions(BOOL NewValue);
Osservazioni
If the AllowQueuedTransactions property is set to TRUE, the publication allows its subscriptions to perform queued-transaction updates at the Subscriber. If AllowQueuedTransactions is set to FALSE, the publication does not allow its subscriptions to perform queued-transaction updates at the Subscriber.
If AllowQueuedTransactions is set to TRUE, use the QueueType property to specify the type of queuing to use.
[!NOTA]
If an application calls AllowQueuedTransactions on an instance of Microsoft SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.