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: sp_sysmail_activate
Undocumented SQL Server 2012 Database Mail Procedures
Undocumented SQL Server 2012 Database Mail Procedures SQL Server 2012 supports the following useful undocumented database mail stored procedures: sp_RunMailQuery sp_SendMailMessage sp_sysmail_activate sysmail_verify_account_sp sysmail_verify_principal_sp sysmail_verify_profile_sp 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 procedure to execute a query if query is specified. Syntax sp_RunMailQuery [...