SET ENABLE_BROKER taking too long to execute

Question

SET ENABLE_BROKER taking too long to execute

Navigation

#1 by (1 votes)

1

I ran the command ALTER DATABASE [Banco] SET ENABLE_BROKER; but it has been running for more than 20 minutes and counting. Would you have a faster way to do it?

sql sql-server

asked by anonymous 10.03.2017 / 13:19

1 answer

innerText does not accept white space You have an error in the syntax of your SQL

score 1 · Accepted Answer

Yes, there is a faster way:

ALTER DATABASE [Banco] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

SQL Server does not allow the command to run until all outstanding transactions have ended. With the above command, all pending transactions are canceled and the ENABLE_BROKER service is activated quickly.