Trouble shoot dbmail in sql server 20005

There are some very useful views for mail:

select * from msdb.dbo.sysmail_allitems

select * from msdb.dbo.sysmail_faileditems

select * from msdb.dbo.sysmail_sentitems

select * from msdb.dbo.sysmail_unsentitems

Every mail send is stored in tables and can be accessed with those views. Note, since this is stored is also takes disk space. It might be nececary to delete old data fromt ime to time. In books on line there is all code needed for this. Search for: "Create a SQL Server Agent Job to Archive Database Mail Messages and Event Logs "