SET ENABLE_BROKER Sets broker enabled for all later newly created database

Hi,

I am using Notification service for one of the application. To set the broker i am using the following TSQL

ALTER DATABASE [DBName] SET ENABLE_BROKER WITH ROLLBACK AFTER 5 SECONDS
GO

This works fine. Issue is after this if i create any new database on the same server, broker is automatically set enabled for it.

Is this the expected behaviour of SQL Broker ? As long as i understand its a database level setting and shuld not change setting on server level for other databases.

Let me know where i am going wrong......

ThanksStart Free Trial