Five Undocumented SQL Server 2014 Database Mail Procedures SQL Server 2014 supports the following useful undocumented database mail stored procedures: sp_RunMailQuery sp_SendMailMessage sp_sysmail_activate sysmail_verify_account_sp sysmail_verify_profile_sp Note. These stored procedures exist in the msdb database, not in master. sp_RunMailQuery The sp_RunMailQuery database mail stored procedure is used to run the mail query. This stored procedure is used in the sp_send_dbmail stored […]
Tag: database mail
Troubleshooting problems with SQL Server 2014 alerts
Troubleshooting problems with SQL Server 2014 alerts If you have problems with SQL Server 2014 alerts, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 alerts bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this […]
Configuring SQL Server Database Mail Feature
Configuring SQL Server Database Mail Feature Author: Basit A. Farooq You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also configure SQL Server Agent Mail to use Database Mail. SQL Server supports SQL Mail for backwards compatibility, but is not recommended for new implementations. Database Mail provides several enhancements over...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Troubleshooting problems with SQL Server 2008 R2 Database Mail
Troubleshooting problems with SQL Server 2008 R2 Database Mail If you have problems with SQL Server 2008 R2 Database Mail, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Database Mail bugs were fixed in SQL Server service packs, you should install the latest SQL...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here