sp_send_dbmail - MS SQL 2008

Posted by Nev_Rahd on Stack Overflow See other posts from Stack Overflow or by Nev_Rahd
Published on 2010-03-16T01:43:23Z Indexed on 2010/03/16 6:06 UTC
Read the original article Hit count: 678

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sp-send-dbmail