Hi, I am trying to set a notification if there is a new entry in the service broker queue. I am using the schema name 'dbo' for the queue.
But when I start listening to the queue table I get an error saying "I cannot find a database table named 'ServiceBrokerQueueTable'Name". Instead of listening to the actual table I just wanted to listen to the service broker queue table. I am not sure if it's possible to listen to the queue table so can you please help me with this issue? Thank you
Hi, I am trying to set a notification if there is a new entry in the service broker queue. I am using the schema name 'dbo' for the queue. But when I start listening to the queue table I get an error saying "I cannot find a database table named 'ServiceBrokerQueueTable'Name". Instead of listening to the actual table I just wanted to listen to the service broker queue table. I am not sure if it's possible to listen to the queue table so can you please help me with this issue? Thank you