ALTER DATABASE DATABASE_Name SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE DATABASE_Name SET ENABLE_BROKER;
SELECT is_broker_enabled FROM sys.databases WHERE name = 'DATABASE_Name'