Can't send Messages with SQL Mail HELP!!!!!

[tecknogeek]

Hello all,
Any help would be apperciated. I can't send e-mail notifications or alerts in SQL 2005. I can send e-mails fine in outlook. I've tried everything to send a message with SQl mail and still come up with this message:




Date 6/28/2007 5:39:41 PM

Log Database Mail (Database Mail Log)



Log ID 352

Process ID 984

Last Modified 6/28/2007 5:39:41 PM

Last Modified By NT AUTHORITY\SYSTEM



Message

1) Exception Information

===================

Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

Message: Could not retrieve item from the queue.

Data: System.Collections.ListDictionaryInternal

TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)

HelpLink: NULL

Source: DatabaseMailEngine



StackTrace Information

===================

at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)

at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)

at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)

at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)
-----------------------------------------------------------

Has anyone seen this before? How can I resolve my issue?
Thanks,
Tecknogeek

 

[onpnt]

forum962


[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]