SQL Server Error : 14607 Details
SQL Server Error: 14607 Severity: 16 Event Logged or not: No Description: %s name is not valid Severity 16 Description: Indicates general errors that can be corrected by the user.
Cause of Error:
For SQL Server Emailing, we need to create an database mail account and then a database mail profile.
If we send a email with below on SQL Management Studio and executed the following script:
@recipients=’[email protected]’, @profile name = ‘Profilename’, EXEC msdb.dbo.sp send dbmail @subject =’test email,’ @body =’test email,’ @body format =’HTML’
We can have a job failed due to an error below for any other user trying to send a email with database mail profile … Read the rest