Archive

Archive for November, 2012

Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42 profile name is not valid Error came when execute test mail

November 6, 2012 Leave a comment

Error:

We need to check the profile name by executing query,

SELECT [profile_id]
,[name]
,[description]
,[last_mod_datetime]
,[last_mod_user]
,’EXEC msdb.dbo.sp_send_dbmail
@profile_name = ‘ ‘ ‘ + name + ‘ ‘ ‘,
@recipients = ‘ ‘abc@abc.com’ ‘,
@subject = ‘ ‘ Test’ ‘,
@body¬† = ‘ ‘Message’ ‘,
@body_format = ‘ ‘HTML’ ‘;’ AS TestSQL
FROM [msdb].[dbo].[sysmail_profile]

Advertisements
Categories: MSSQL