Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

SQL server - call asp mail object remotely??

What is the procedure to create an object such as asp mail from a stored procedure, REMOTELY??? Any help would be appreciated.....ie, the asp mail object resides on another server.Thanks.
0
marshallgarza
Asked:
marshallgarza
1 Solution
 
adatheladCommented:
hi,

I don't think this is possible, the component would need to be installed on the local server. This would be the best way to go about it.
However, if that's not possible and you have SQL on the remote server, wrap all the functionality using the asp mail component into a procedure on that remote server. Then, your local SQL Server can link to that remote server and pass any data across via parameters to the procedure which would handle all the object handling.

HTH.
Cheers
0
 
CleanupPingCommented:
marshallgarza:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now