Tuesday, February 23, 2010


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.'

1 comment:

  1. 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.