This is the correct script to set the broker service on database :
USE [master]
GO
ALTER DATABASE [Dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [Dbname] SET DISABLE_BROKER
ALTER DATABASE [Dbname] SET NEW_BROKER
ALTER DATABASE [Dbname] SET ENABLE_BROKER
GO
ALTER DATABASE [Dbname] SET MULTI_USER
GO
Bahram
|