I am trying to set up automatic alerts on SQL 2000, SP 3a using Outlook 2000
and Exchange. I have created a profile which successfully sends and receives
e-mails, but when I try to enter the profile name in the drop down menu in
the SQL Menu configuration it does not appear. If I manually type the

Hi Cyprus -

You'll probably have more luck in another newsgroup; this one is
dedicated to Notification Services, the add-on to SQL Server 2000.

In the meantime, here are a few resources for you to consider:

http://support.microsoft.com/kb/311231/EN-US/
http://support.microsoft.com/kb/315886/EN-US/
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp


excerpt from http://support.microsoft.com/kb/315886/EN-US/ :
Q10: Why are no mail profiles listed in the drop-down box in SQL Mail
properties?

A10: One possible cause is that the service that SQL Server runs under
is configured to start with the Local System account. The Local System
account does not have a Windows login associated with it; therefore, no
mail profiles can be configured for SQL Server. Refer to the Check Your
Configuration section in this article for instructions on choosing the
proper service startup account.

Another possible cause is that there is no mail profile for the account
used to start the MSSQL Server service. To configure a mail profile to
use with SQL Server Mail, you must first log on to the Windows computer
on which SQL Server is running with the same login and password used to
start the MSSQL Server service.

You may not have Microsoft Outlook set as the default e-mail client.
Refer to the Check Your Configuration section in this article for
instructions on examining your default e-mail program.




HTH...
Joe Webb
SQL Server MVP

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



[quoted text, click to view]