When I restore a database I get the following message:"The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported." What should I do?
Open SQL Server Studio Manager and post the following two queries:
ALTER DATABASE "<the database name>" SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
and then
ALTER DATABASE "<the database name>" SET ENABLE_BROKER;
