
March 29th, 2007, 07:15 AM
|
|
Registered User
|
|
Join Date: Mar 2007
Posts: 2
Time spent in forums: 32 m 48 sec
Reputation Power: 0
|
|
|
SQL mail
In our SQL server (2000), we have configured SQL mail to send some acknowledgement using xp_sendMail . We have selected outlook as the MAPI session for that.
But now one of our new DTS package needs to use xp_sendMail stored procedure to alert the users from the same SQL server using a different MAPI session.
Is it possible to have multiple MAPI sessions and SQL mail configurations in same server?
If its possible, how can we achieve this?
Otherwise is there any work-around solutions to attain the similar solution?
|