0 out of 1 rated this helpful - Rate this topic

Troubleshooting Database Mail

SQL Server 2008 R2

Database Mail is designed to help database administrators quickly isolate and correct problems. This section describes solutions for common problems.

In This Section

Troubleshooting Database Mail: General steps
Troubleshooting Database Mail: Sending Test E-Mail
Troubleshooting Database Mail: Could not find stored procedure 'sp_send_dbmail'
Troubleshooting Database Mail: Profile not valid
Troubleshooting Database Mail: Permission denied on sp_send_dbmail
Troubleshooting Database Mail: Mail queued, not delivered
Troubleshooting Database Mail: Mail queued, no entries in sysmail_event_log or Windows Application Event Log
Troubleshooting Database Mail: Send mail from remote server while troubleshooting local server

Tasks

How to: Activate Service Broker Message Delivery in Databases (Transact-SQL)

How to: Create a SQL Server Agent Job to Archive Database Mail Messages and Event Logs

Reference

Database Mail Views (Transact-SQL)

Concepts

Database Mail Architecture

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

Annotations

FAQ

© 2012 Microsoft. All rights reserved.

Terms of Use | Trademarks | Privacy Statement | Site Feedback Site Feedback

Site Feedback

x

Tell us about your experience...

Did the page load quickly?

Yes No

Do you like the page design?

Yes No

Tell us more