How long should I expect ALTER DATABASE … SET ENABLE_BROKER to run?

I’ve seen this question comming back again and again on forums and discussion groups. The ALTER DATABASE … SET ENABLE_BROKER seems to run forever and doesn’t complete. How long should one wait? This statement completes imeadetly, but the problem is that is requires exclusive access to the database! Any connection that is using this database … Continue reading How long should I expect ALTER DATABASE … SET ENABLE_BROKER to run?