I am using SQL 2000, Outlook 2000 as my mail client and Lotus Notes as my POP3 server.
Recently my .pst file became corrupt, so I had to recreate my mail profile. I can do the following:
1. Open Outlook and send/receive mail with the account
2. I can successfully Test the profile within Enterprise Manager/SQL Mail
3. I can successfully send a simple mail message from Query Analyzer.
My problem is that when I try to send mail from a trigger, the trigger hangs and does not process. If I comment out the xp_sendmail code in the trigger, the trigger works.
I have an exact copy of this trigger on a test box and it works fine.
After I recreated and tested my mail profile, I restarted the SQL Server service, however, I have not rebooted the machine yet.
Recently my .pst file became corrupt, so I had to recreate my mail profile. I can do the following:
1. Open Outlook and send/receive mail with the account
2. I can successfully Test the profile within Enterprise Manager/SQL Mail
3. I can successfully send a simple mail message from Query Analyzer.
My problem is that when I try to send mail from a trigger, the trigger hangs and does not process. If I comment out the xp_sendmail code in the trigger, the trigger works.
I have an exact copy of this trigger on a test box and it works fine.
After I recreated and tested my mail profile, I restarted the SQL Server service, however, I have not rebooted the machine yet.
