October 15, 2002 at 6:55 am
xp_sendmail will not return results in e-mail from the default instance of SQL2k.
When running something as simple as:
exec master..xp_sendmail
@recipients = 'name@company.com',
@subject = 'TEST Default',
--@message= 'See Attachments',
--@attach_results ='true',
@echo_error = 'true',
@query = '
select @@version'
Results from default instance:
(Rows Affected: 1)
Results from nameed instance:
-----------------------------------------------------------------
---------
Microsoft SQL Server 2000 - 8.00.665 (Intel X86)
Jul 29 2002 15:02:32
Cop
yright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 2)
(Rows Affected: 1)
It returns results from all instances as attatchment? Any suggestions?
Thanks in advance!!
Kevin
October 25, 2002 at 12:00 pm
This was removed by the editor as SPAM
October 25, 2002 at 12:49 pm
Just tested, works fine here. Tried stop/start mail?
Andy
October 28, 2002 at 7:20 am
I noticed a difference in the registry settings for the SQL Servers where xp_sendmail is working and the ones that xp_sendmail is not working. Found Microsoft Knowledge Base Article - Q280720, doesn't really pertain to my problem but I checked the registry on the servers and found that the directory: HKLM\Software\Microsoft\MSSQLSERVER\SQLMAPI is there for the servers that send blank e-mails. The servers that are working correctly do not have this directory? This is for the default instances. The named instances do not have this directory either,HKLM\Software\Microsoft\Microsoft SQL Server\InstanceNameHere\SQLMAPI ,and xp_sendmail is working fine. I delected the SQLMAPI directory and all is well with xp_sendmail.
-Kevin
October 28, 2002 at 7:21 am
I noticed a difference in the registry settings for the SQL Servers where xp_sendmail is working and the ones that xp_sendmail is not working. Found Microsoft Knowledge Base Article - Q280720, doesn't really pertain to my problem but I checked the registry on the servers and found that the directory: HKLM\Software\Microsoft\MSSQLSERVER\SQLMAPI is there for the servers that send blank e-mails. The servers that are working correctly do not have this directory? This is for the default instances. The named instances do not have this directory either,HKLM\Software\Microsoft\Microsoft SQL Server\InstanceNameHere\SQLMAPI ,and xp_sendmail is working fine. I deleted the SQLMAPI directory and xp_sendmail is now working correctly.
-Kevin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply