If you are asking for SQL 2000, check the following link...for SQL 2005 you check BOL for database mail which has the examples... http://www.sqldev.net/xp/sp_smtp_sendmail.htm http://technet.microsoft.com/en-us/library/ms190307.aspx