后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。
The AllowQueuedTransactions property specifies whether a publication allows queued-transaction updates to be performed at the Subscriber.
语法
object
.
AllowQueuedTransactions [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
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);
备注
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.
.gif "ms143108.note(zh-cn,SQL.90).gif") 注意： |
|---|
| 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. |