set enable_broker with rollback immediate - SqlDependency

Question

 SqlDependency

Sometimes, you cannot run this one: alter database hob_v2 set enable_broker with rollback immediate;

ALTER DATABASE hob_v2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database hob_v2 set enable_broker with rollback immediate;
ALTER DATABASE hob_v2 SET MULTI_USER