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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-07-13 : 05:19:57
|
| in front-end:I am getting error at dynamic XML creation for Menu navigation. After login into applicationException Details:-“The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.Please enable the Service Broker for this database if you wish to use notifications.”so i used the following statements to fix this issues:ALTER DATABASE dbname SET NEW_BROKER WITH ROLLBACK IMMEDIATE;ALTER DATABASE dbname SET ENABLE_BROKER; SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname'after issuing this staement, the front end is working fine.but after some time ,again its throwing same error as mentioned above.how to fix this? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-07-13 : 11:47:11
|
| Does the "SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname'" still indicate that the broker is enabled? Are you convinced that the message is referring to the same database? Also, don't cross post.=======================================A couple of months in the laboratory can save a couple of hours in the library. -Frank H. Westheimer, chemistry professor (1912-2007) |
 |
|
|
|
|
|
admin issues