64 bit SQL Server & SMTP Sendmail
-
We are currently implementing a new 64 bit SQL Server solution to meet our performance demands.
We have a need to utilize xp_smtp_sendmail, or a another "SMTP" based stored procedure to send mail outbound with 64 bit.
Does anyone have a 64 bit complied version of the xp_smtp_sendmail procedure's dll? Or the code for the DLL and I can complie it?
-
See http://www.sqlservercentral.com/scripts/contributions/510.asp I have been using this script for a while now. I prefer it to xp_smtp_sendmail as I can use it send the results of a query. I can also modify the code if I choose as well. Best of all no dll.
Francis
-
Audie,
I'd have to recommend our product, sqlSentry, which includes our 64-bit compliant interface-compatible replacement for xp_sendmail. It's not free, however it offers several benefits over other xp_sendmail replacements, including:
- sp_sentry_mail is a standard stored procedure, and doesn’t require installation of or depend on any dll’s, scripts, or other components on each and every SQL Server (including no dependencies on CDO)
- Configuration is centralized, so you don't need to touch every SQL Server or pass SMTP parameters with every call. You configure SMTP settings once from the sqlSentry Console, then call the proc just like you would xp_sendmail.
- The procedure is auto-deployed from the sqlSentry Console to each SQL Server with a couple of clicks, ie, you don't need to run a setup script on every server.
- Fault tolerance -- if you run more than one sqlSentry Server service, you'll have full fault tolerance ensuring your emails are always delivered. With distributed solutions you don't really have any fault tolerance since each install is self-contained and can fail on an individual server for various reasons.
You can download a 15-day trial from our website:
Ok, that's enough shameless self-promotion for one post
Greg Gonzalez
Product Manager
sqlSentry
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply