Variable WorkQueueProceduresConst
WorkQueueProcedures: {
AcknowledgeCancel: "spWorkQueueAcknowledgeCancel";
AcquirePublishOrderLock: "spWorkQueueAcquirePublishOrderLock";
AcquireSweepLock: "spWorkQueueAcquireSweepLock";
CancelInFlightDelivery: "spWorkQueueCancelInFlightDelivery";
ClaimPartitionCandidate: "spWorkQueueClaimPartitionCandidate";
ClaimUnpartitioned: "spWorkQueueClaimUnpartitioned";
CompleteDelivery: "spWorkQueueCompleteDelivery";
ConfirmDeduplication: "spWorkQueueConfirmDeduplication";
DeadLetterDelivery: "spWorkQueueDeadLetterDelivery";
DiscardDelivery: "spWorkQueueDiscardDelivery";
ExpireLeases: "spWorkQueueExpireLeases";
ExpireLeasesAll: "spWorkQueueExpireLeasesAll";
ExtendLease: "spWorkQueueExtendLease";
InsertDeliveries: "spWorkQueueInsertDeliveries";
InsertMessage: "spWorkQueueInsertMessage";
ListDeadLetters: "spWorkQueueListDeadLetters";
ListPartitions: "spWorkQueueListPartitions";
PurgeExpiredDeduplications: "spWorkQueuePurgeExpiredDeduplications";
PurgeOrphanMessages: "spWorkQueuePurgeOrphanMessages";
PurgeTerminalDeliveries: "spWorkQueuePurgeTerminalDeliveries";
ReadCommittedSnapshotState: "spWorkQueueReadCommittedSnapshotState";
ReleaseDeduplication: "spWorkQueueReleaseDeduplication";
ReleaseDelivery: "spWorkQueueReleaseDelivery";
ReplayDelivery: "spWorkQueueReplayDelivery";
ReserveDeduplication: "spWorkQueueReserveDeduplication";
RetryDelivery: "spWorkQueueRetryDelivery";
SelectDeduplicationOwner: "spWorkQueueSelectDeduplicationOwner";
SelectLeaseState: "spWorkQueueSelectLeaseState";
SelectMessage: "spWorkQueueSelectMessage";
SelectPartitionCandidates: "spWorkQueueSelectPartitionCandidates";
SubscriptionBacklog: "spWorkQueueSubscriptionBacklog";
SubscriptionStats: "spWorkQueueSubscriptionStats";
} = ...
Type Declaration
ReadonlyAcknowledgeCancel: "spWorkQueueAcknowledgeCancel"
ReadonlyAcquirePublishOrderLock: "spWorkQueueAcquirePublishOrderLock"
ReadonlyAcquireSweepLock: "spWorkQueueAcquireSweepLock"
ReadonlyCancelInFlightDelivery: "spWorkQueueCancelInFlightDelivery"
ReadonlyClaimPartitionCandidate: "spWorkQueueClaimPartitionCandidate"
ReadonlyClaimUnpartitioned: "spWorkQueueClaimUnpartitioned"
ReadonlyCompleteDelivery: "spWorkQueueCompleteDelivery"
ReadonlyConfirmDeduplication: "spWorkQueueConfirmDeduplication"
ReadonlyDeadLetterDelivery: "spWorkQueueDeadLetterDelivery"
ReadonlyDiscardDelivery: "spWorkQueueDiscardDelivery"
ReadonlyExpireLeases: "spWorkQueueExpireLeases"
ReadonlyExpireLeasesAll: "spWorkQueueExpireLeasesAll"
ReadonlyExtendLease: "spWorkQueueExtendLease"
ReadonlyInsertDeliveries: "spWorkQueueInsertDeliveries"
ReadonlyInsertMessage: "spWorkQueueInsertMessage"
ReadonlyListDeadLetters: "spWorkQueueListDeadLetters"
ReadonlyListPartitions: "spWorkQueueListPartitions"
ReadonlyPurgeExpiredDeduplications: "spWorkQueuePurgeExpiredDeduplications"
ReadonlyPurgeOrphanMessages: "spWorkQueuePurgeOrphanMessages"
ReadonlyPurgeTerminalDeliveries: "spWorkQueuePurgeTerminalDeliveries"
ReadonlyReadCommittedSnapshotState: "spWorkQueueReadCommittedSnapshotState"
ReadonlyReleaseDeduplication: "spWorkQueueReleaseDeduplication"
ReadonlyReleaseDelivery: "spWorkQueueReleaseDelivery"
ReadonlyReplayDelivery: "spWorkQueueReplayDelivery"
ReadonlyReserveDeduplication: "spWorkQueueReserveDeduplication"
ReadonlyRetryDelivery: "spWorkQueueRetryDelivery"
ReadonlySelectDeduplicationOwner: "spWorkQueueSelectDeduplicationOwner"
ReadonlySelectLeaseState: "spWorkQueueSelectLeaseState"
ReadonlySelectMessage: "spWorkQueueSelectMessage"
ReadonlySelectPartitionCandidates: "spWorkQueueSelectPartitionCandidates"
ReadonlySubscriptionBacklog: "spWorkQueueSubscriptionBacklog"
ReadonlySubscriptionStats: "spWorkQueueSubscriptionStats"
The guarded-write procedures of
V202610061701__v6.2.x__Work_Queue_Guarded_Write_Sprocs.sql(plan 12 / CD9). Keys match the builder methods that call them;procedureParity.test.tschecks that every name and its parameter list, in order, exists in the migration exactly as the builders render it.