SQL 2005 : Database Mail Setup

1. Enable Database Mail feature via Surface Area Configuration for Features.
2. In SSMS, Use Database Mail Configuratin Wizard to create account and profile.
3. Select a default profile.
4. Create Operator.
5. If you would use Alert to notifiy operator, enable Mail Profile in Alert system option of SQL Server Agent.
6. Restart the SQL Server Agent.
7. You are ready to use Database Mail to notify the operator now.