开发者

Purpose of QueryNotificationErrorsQueue in SQL Server

What is the functionality of QueryNotificationErrorsQueue in MS SQL Server?

As the only permission difference between SQLDependency and SQLNotificationRequest is of RECEIVE permission on QueryNo开发者_JAVA百科tificationErrorsQueue. SQLDependency require it and SQLNotificationRequest wont require.


It is the initiator side queue for query notifications. It is never physically used, messages enqueued into it (which could be only error responses from QN notification delivery attempts) are intercepted at enqueue time and get special treatment. Same happens for the other system queues: EventNotificationErrorsQueue and ServiceBrokerQueue. It is not possible for applications to ever receive messages from these three system queues.

Neither SqlDependecy nor SqlNotificationRequests should require RECEIVE permissions on the QueryNotificationErrorsQueue. Can you point out where did you read the information that SqlDependency requires it?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜