I have service broker running on different servers.
Just recently I had to rebuild one of the test servers and it had a complete service broker solution running there.
For the next time I need to rebuild a server that has service broker running in any of its databases
-- Message Types SELECT * FROM sys.service_message_types;
Basically using the scripts below, how can I be able to script all the service broker elements for a particular database?
-- Message Types SELECT * FROM sys.service_message_types; -- Contracts SELECT * FROM sys.service_contracts; -- Queues SELECT * FROM sys.service_queues; -- Services SELECT * FROM sys.services; -- routes SELECT * FROM sys.routes; -- Endpoints SELECT * FROM sys.endpoints;