select is_broker_enabled from sys.databases where name='msdb'
alter database msdb set enable_broker
alter queue ExternalMailQueue with status = on
to Fix The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.'
I have heard about another way of restore corrupt data from a sql server .mdf file. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.
ReplyDelete