sp_send_dbmail - MS SQL 2008
- by Nev_Rahd
sp_send_dbmail works fine on one server as below:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'xxxx Mail Profile',
@recipients = 'xxx.com',
@body = 'xxxxxxxx',
@subject = 'xxx - Please do not reply to this email';
But on other server where got same Mail profile setup
throws an error saying it excepts value for parameters
@copy_recipients, @blind_copy_recipients (though these are optional)
Where do I need to check ? any help please
Thanks