September 2, 2003 at 9:40 am
I execute the following code in Query Analyzer:
EXEC master.dbo.xp_sendmail @subject = 'test', @recipients = 'test@test.com',
@query = 'select 10', @attach_results = 'true'
This is the error I got:
Server: Msg 18024, Level 16, State 1, Line 0
xp_sendmail: failed with operating system error 80
We are running SQL Server 2000. When we change @attach_results to 'False' then it works fine.
Has anyone seen this before? Does anyone know what error 80 means? Where can I find a list of all Windows 2000 operating errors?
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
September 2, 2003 at 3:40 pm
We found a solution that worked for us. We read many posts on other sites and finally found one that told us the attachments could not be sent out anymore if a folder found at C:\Documents and Settings\<the MSSQLServer logon account>\Local Settings\Temp
has more than 65,000 files in it. Ours had more than 65,000 in it. All were SQLx.TMP files and were of size 0 KB. At this point you will get operating system error 80 and no e-mail will be sent.
Yesterday we had a DTS package go into an infinite loop and by the time we had stopped it, it had sent over 60,000 e-mails. Appently there was one file for each e-mail that had an attachment (all of these did).
After deleting all the files from that temp directory we rebooted our server and now everything is fine again.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply