Troubleshooting Database Mail: Could not find stored procedure 'sp_send_dbmail'

The sp_send_dbmail stored procedure is installed in the msdb database. You must either execute sp_send_dbmail from the msdb database, or specify a three-part name for the stored procedure.

Use Database Mail Configuration Wizard to enable and configure database mail.

See Also

Concepts

Database Mail Architecture
Mail Host Database

Other Resources

sp_send_dbmail (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance