How to Enable SQL Server Service Broker
Run this query
ALTER DATABASE DataBaseName
SET ENABLE_BROKER
WITH ROLLBACK IMMEDIATE
We can run the query without rollback statement. But it takes so much time.
And we can find out the result by running this query.We can come to know that whether services have been restored or not.
SELECT [name], is_broker_enabled
FROM sys.databases
WHERE [Name]='DatabaseName'
ALTER DATABASE DataBaseName
SET ENABLE_BROKER
WITH ROLLBACK IMMEDIATE
We can run the query without rollback statement. But it takes so much time.
And we can find out the result by running this query.We can come to know that whether services have been restored or not.
SELECT [name], is_broker_enabled
FROM sys.databases
WHERE [Name]='DatabaseName'
Comments