Aspet Golestanian Namagerdi (3/4/2013)
In sysmail_sentitems,there is not any record.In sysmail_unsentitems,In includes all the test emails I have tried
In sysmail_event_log does not show that DatabaseMail process has been started to stopped at all.
The last two event in this table are(I manullay stopped and started the mail Queue):
The mail queue stopped by login...
The mail queue started by login...
Why don't you try seaching:
SELECT *
FROM msdb.dbo.sysmail_allitems
Why haven't you tried opc.three queries?
Whay are you trying to execute the DatabaseMail.exe?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/