Displaying posts tagged with

“Service Broker”

Configure Service Broker in SQL Server 2012

Configure Service Broker in SQL Server 2012. Initiator Script Step1 : Create Database, Master Key and Initiator Certificate Step2 : Create Target Certificate, Login and Endpoint Step3 : Create User, Master Key, Initiator and Target Certificate Step4 : Create Message Type, Contract, Queue, Service, Route and Binding Target Script Step1 : Create Database, Master Key [...]

Purge records of Sys.Transmission_Queue of Service Broker in SQL Server

Purge records of Sys.Transmission_Queue of Service Broker in SQL Server. Today i got one issue on service broker for sys.transmission_queue. Service broker configured well and working fine, suddenly service broker tranmission_queue goes high and high. I have checked Transfer_Status to check the error if there is any, but i can’t see any error in Transfer_Status. [...]