Hello, we have Service Broker running for one of our applications. We keep running into problems where occassionally it seems to lock up and no messages get sent. And it seems to be holding exclusive locks on the target queue as well as some internal table it uses, and these ...
I am new to Service Broker and wanted to do some testing with it, when i open Surface Area Configuration Tool and select the Service Broker feature i get the following error : "This instance does not have a Service Broker endpoint."
Sorry if this is a silly question; I'm new to MS SQL Server... In trying to simply copy a database an error occured (unfortunately I didn't record the original error as it has happened before) resulting in the original database instance remaining in Single User mode.