Displaying posts tagged with

“Transmission_Queue”

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. [...]