Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
EugeneLim11
Posting Yak Master
167 Posts |
 Posted - 2008-07-22 : 23:54:12
|
| Hi, I have a huge database that is recently corrupted. I have restored the backup for the database but this kind of destroyed the broker for the database.To ensure I have a new broker, I ran the command. alter database databasename set NEW_BROKERGOThe problem is that after 1 day, the MSSQL server has not finished executing this query. I am at a loss to why or how. If I stop the exection, I will have no broker defined error in my applications. Please, did I forget something? Assistance is very much appreciated. Eugene |
|
|
|
|
|
broker for database