Have Geek Brain

Service broker won't start

ALTER DATABASE [Database name] SET ENABLE_BROKER; Doesn't respond and works endlessly. SQL Agent service is running, what are the odds?

thanks

+2


a source to share


2 answers


How long should I wait for ALTER DATABASE ... SET ENABLE_BROKER to run?

ALTER DATABASE ... SET ENABLE_BROKER

exclusive access to the database is required and it will block if there is any other session in the database. To force it, you can use a suggestion WITH ROLLBACK

that will kill any session that blocks your ALTE

R:



ALTER DATABASE [<dbname>] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;
+2


a source


First you must kill all processes for this database. Here's how to do it.



http://www.kodyaz.com/articles/kill-all-processes-of-a-database.aspx

0


a source






More articles:


All Articles