I have two instances of SQL 2008. One was upgraded from SQL 2000 and one was
a clean, new install.

SQL Mail operates perfectly on both instances.
DB Mail operates perfectly on the newly installed instance.
On the upgraded instance, DB Mail does not send any mail.

Configuration of my profile and account looks identical to my other instance
where db mail works. Configuration of the 'alerts' tab in the SQL Agent
properties has db mail choosen and the only profile i created selected.


All messages sent via sp_send_db mail and those sent via the 'test email'
option are visible in the sysmail_allitems queue and remain there as 'unsent'
until i stop/start the service using:
exec msdb.dbo.sysmail_stop_sp
exec msdb.dbo.sysmail_start_sp

The only messages in the sysmail_event_log are 'mail queue stopped by login
domain\myuser', 'mail queue started by login domain/myuser' and 'activiation
successful.'.

selecting from the externalmailqueue has 21 rows, which is the same number
that is returned by sysmail_allitems.

any thoughts?
thx.

Are you sure that you have enabled Service Broker for this database as well
as the option 'Database Mail XPs' ?

-- Service Broker:

use master
go
alter database TheDatabase
set enable_broker;
go


-- 'Database Mail XPs':

sp_Configure 'show advanced', 1
go
reconfigure
go
sp_Configure 'Database Mail XPs', 1
Go
reconfigure
go

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"cc" <cc (AT) discussions (DOT) microsoft.com> wrote