Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 xp_sendmail failure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-24 : 09:19:33
Tom writes "Hi!

I am attempting to create a trigger on a database table to send an email message when a record is added to the table. In general, this is an extremely simple procedure, and I am having no problem creating or executing the trigger.

I have done this on one server/database successfully, but, on another server, I get a "MAPI login failure" when the trigger executes.

So far as I know (and our server administrator verifies), the servers are set up identically, and there seem to be no problems with other mail messages being sent from this particular server.

The only possible complication I can see is that the insert is being performed by an Active Server Page. However, the trigger does not perform properly, even when the record is inserted "manually" from Query Analyzer (even logged in as SA).

Any thoughts on where to look?"
   

- Advertisement -