Configuring SQL Mail
SQL Mail must run using a mail profile in the same domain account used to start an instance of Microsoft SQL Server. In SQL Server Management Studio, SQL Mail can be found in the Management folder for the instance. After configuring SQL Mail, you can use the SQL Mail stored procedures to send and receive mail.
Note
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.. To send mail from SQL Server 2005, use Database Mail.
Procedures
How to: Configure Mail Profiles for Use by SQL Mail (Windows)
How to: Set Up SQL Mail (SQL Server Management Studio)