Database Support FAQ

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;