Here's the latest of what I've tried andma am now going to make sure the exchange server is talking named pipes with the sql server.

1. made nt account the same...

Hi Dave thanks for your help.

I'll give xp_smtp_sendmail a shot...

Also - I'm running MS SQL Server v7.0 on XP and the MAPI profile is setup on Exchange.

Under Services,...

I also might add that:

begin

use master

exec xp_stopmail

end

does not work either.... from query analyzer

exec master..xp_cmdshell 'dtsrun -S[server_name] -U[domain]\[login] -E -Ntest_email'

also works...but can't figure out how to get:

exec master..xp_sendmail to work...

I should also add that once I get the above working in query analyzer I'll attach a query (@query = [stored_proc_name]

Thanks - I can send email thru DTS via a task. This works.

Trying to create a stored procedure from the above doesn't work.

SQL Mail is working - so this s/b...