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