Dear Gurus!
Can't anybody get reference on example how to use Service Broker?
Now I get an error :
The query notification dialog on conversation handle '....' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8470</Code><Description>Remote
service has been dropped.</Description></Error>'.
I did as in http://dotnet.dzone.com/articles/c-sqldependency-monitoring.
Must I create Master key for my database?
What I must to do else to satisfy ServiceBroker to deal with master key encription?
Must I use next code from previous reference:
USE [road]
CREATE QUEUE NewEmployeeAddedQueue;
CRE ...
Go to the complete details ...