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?
精彩评论