Hello,

I have SQL Server 2000 installed on a 64-bit server. SQL mail does not work
from there. I got the following error message:

Server: Msg 18038, Level 16, State 1, Line 0
SQL Mail does not work with the 64-bit version of SQL Server

Does any one know if there is a workaround to send SQL query results to
users via an email?

Any input to this is highly appreicated.


Many Thanks,
Lianne

In SQL Server 2000, SQL Mail depends on the following extended stored
procedures, which are not supported in the 64-bit world.

xp_startmail
xp_stopmail
xp_sendmail
xp_readmail
xp_deletemail
xp_findnextmsg
sp_processmail

I don't know off hand of a good workaround for this.

SQL Agent Mail is supported on the 64-bit platform, BTW.

HTH...

--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On Thu, 27 Jul 2006 13:28:01 -0700, Lianne Kwock
[quoted text, click to view]