开发者

Purpose of QueryNotificationErrorsQueue in SQL Server

开发者 https://www.devze.com 2023-02-04 13:43 出处:网络
What is the functionality of QueryNotificationErrorsQueue in MS SQL Server? As the only permission difference between SQLDependency and SQLNotificationRequest is of RECEIVE permission onQueryNo开发者

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

精彩评论

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

关注公众号