memory allocation for stored procedure???

[wawer]

Hi everybody,
I'm writing a stored procedure and a trigger to send mail from SQL Server 7.0. The stored procedure will call an ASPEmail component for mail sending task, and the trigger will call the stored procedure for each new recordset in a table. All of this seem to be working. But the problem is that for a new recordset, the procedure is only able to send the first right mail to the right person. If I try to redo the inserting task with the same data, it begins to send mail to everybody. I've red thousands of manuals but could not understand why. Is there a problem relative to the memory allocated to the stored procedure?
Thank you for help.

 

[aalmeida]

I don't know what "ASPEmail component" is but I know I have no problem using the IMAP procedures that comes with SQL Srv to send and receive e_mails.
Take a look at BOL on :
sp_processmail;
System Stored Procedures (SQL Mail Extended Procedures);
xp_findnextmsg;
xp_readmail;
xp_sendmail;
xp_startmail;
xp_stopmail.

They work just fine for me
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[wawer]

Thank you for the advice.
In fact, I realized that I made a mistake: The table name was completely wrong. And it's normal that it didn't work )
Thank you