Viewing 4 posts - 1 through 4 (of 4 total)
Just as a follow up to close out this. I had uninstalled and reinstalled SQL2008 SP1 which gave me the same result. Finally I just uninstalled and...
September 3, 2009 at 9:17 am
Tried your script and received the same result. It is just like the server isn't recognizing the flag is enabled for "Database Mail XPs"
August 27, 2009 at 3:17 pm
I have tried it via the GUI as well and get the same error.
August 26, 2009 at 7:17 am
Enabling the broker requires exclusive rights to the database.
Put MSDB in single-user mode and then fire the command:
ALTER DATABASE [msdb] SET ENABLE_BROKER
August 24, 2006 at 3:06 pm
Viewing 4 posts - 1 through 4 (of 4 total)