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
sql-server
|sp-send-dbmail
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