by Hi Everyone!
Can anyone help with the following:
I had the following set up up and working for months:
Server A: SQL 2000, SP2, Default, Replicates to Server C1, No Mail
services set up
Server C1: SQL 2000, SP2, Instance, Subscriber to Server A, Mail
Services set up and all working fine.
When an email notification is required from Server A a Stored procedure
using the XP_SendEmail, located on Server C1 is called
I have put in place another similar set up:
Server B: SQL 2000, SP2, Default, Replicates to Server C2, No Mail
services set up
Server C2: SQL 2000, SP2, Instance, Subscriber to Server B a Stored
procedure using the XP_SendEmail, located on Server C1 is called
The problem is as follow:
I add the mail profile to Server C2 and test it, it works.
I add the mail profile reference to the SQL Agent properties, restart
the SQL agent.
Run the email stored procedure and I get:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception
c0000005 EXCEPTION_ACCESS_VIOLATION.
SQL Server is terminating this process.
AS soon as I disabled the mail profile reference in the SQL agent the
email on Server C1 is working again.
I have tried creating different Mail Profile, one for each Server, same
results
I have tried running the email from Server C1 and Server C2 same
results.
I have find an article to the problem: Q305576, but it explains that SP2
should resolve the issue.
All the servers involve in my set up have SP2 installed.
Can anyone suggests anything on this issue?
Thank you!
Corinne