SET ENABLE_BROKER taking too long to run

Asked

Viewed 192 times

1

I executed the command ALTER DATABASE [Banco] SET ENABLE_BROKER; but it’s been running for over 20 minutes and counting. It would have a faster way to execute?

sql sql-server

1 answer

2


Yes, there is a quicker way:

ALTER DATABASE [Banco] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

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

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.