Share
Report
1,080Hi,
I'm having a problem during the setup of Business Alerts in the GP2010 and SQL Server 2008 R2. I went thru to this links (below) to setup the Database Mail.
https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;915097
http://www.c-sharpcorner.com/uploadfile/suthish_nair/database-mail-configuration-in-sql-server-2008/
after the Database Mail configured, I ran the sql script (below) to make sure that the configuration is working then I sucessfully send and received the email.
EXEC msdb.dbo.sp_send_dbmail
@recipients='vm.mohammedfauzi@gmail.com',
@subject = 'SQL:DataBase Mail Test',
@body = 'Hello Test From SQL.Hello Test From SQL.',
@profile_name = 'The Profile you created in Configure Database Mail',
@body_format = 'HTML'
During the setting up the Business Alerts in GP2010 I encountered this warning message "The following error occurred in SQL Server: XP_sendmail: Procedure expects parameters @user, which was not supplied"
I read some blog it says "xp_sendmail is obsolete and we can use sp_send_dbmail instead."
I have been searching the solution over the net, but I was not able to find. Please advice.
Thanks,
Ronie
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
