Hi,

I am running SQL Server 2000 on a machine not connected to any
network. Can someone please give me a step by step instruction on how
to setup SQL Server to send emails? I can send email through IIS in my
..NET application but I am also wanting to send emails from a stored
procedure.

I am running Outlook 2003 - Windows XP.

(I have tried adding a user profile but there is none in the drop-down
list.)

Thanks,
Jack

You should probably start here if you want to use SQL Mail:

http://support.microsoft.com/kb/263556

You could also look at xp_smtp_sendmail, which is an alternative to
xp_sendmail:

http://www.sqldev.net/xp/xpsmtp.htm

Simon