Enabling Service Broker in SQL Server 2008
In case anyone else is looking for a solution to this problem, the following command worked great for me. It releases all other connections to the database instead of waiting. ALTER DATABASE [DBNAME] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE