SQL Server – Sending Mail [2005]

EXEC msdb.dbo.sp_send_dbmail
    @recipients=N’danw@Adventure-Works.com’,
    @body=N’The master database is full.’ ;

http://msdn2.microsoft.com/en-US/library/ms187891.aspx