title: Enable SQL Server Broker taking too long
body: <p>I have a Microsoft SQL server 2005 and I tried to enable Broker for my database with those T-SQL:</p>
  
  <pre><code> SELECT name, is_broker_enabled FROM sys.databases 
   -- checking its status 0 in my case
   ALTER DATABASE myDatabase SET ENABLE_BROKER
  </code></pre>
  
  <p>The <code>Alter Database</code> takes long time to process. It is now over half hour and it is still running. Not sure if it is waiting for something else or I have to clean up anything first, such as delete all the messages, contract, queue and services under service broker?</p>