Thursday, March 22, 2012

error in xp_sendmail

Hi All,
I am using SQL SERVER 2005 Standard Edition. I have enabled
database mail from Surface Area Configuration and also configured
database mail from Object Explorer ->management.
When i am trying to send mail by using extended stored
procedure xp_sendmail i am getting error as follows:
xp_sendmail: Procedure expects parameter @.user, which was not
supplied.
It will be a great help if you guys can help me.
Thanks in advance.Hi,
It looks like you configured Database Mail, a new feature in SQL Server
2005, but are trying to send e-mail using xp_sendmail, a stored procedure
that uses SQL Mail, which is a different SQL Server feature. Use
sp_send_dbmail instead. Look BOL for more details and examples.
Make sure you really configured Database Mail, right-click Database Mail and
select 'Send Test E-mail' to test that it works.
By the way, SQL Mail, according to BOL, will be removed in a future version
of SQL Server.
Hope this helps,
Ben Nevarez
"mohit" wrote:
> Hi All,
> I am using SQL SERVER 2005 Standard Edition. I have enabled
> database mail from Surface Area Configuration and also configured
> database mail from Object Explorer ->management.
> When i am trying to send mail by using extended stored
> procedure xp_sendmail i am getting error as follows:
> xp_sendmail: Procedure expects parameter @.user, which was not
> supplied.
> It will be a great help if you guys can help me.
> Thanks in advance.
>|||On Jan 18, 12:51=A0pm, Ben Nevarez
<BenNeva...@.discussions.microsoft.com> wrote:
> Hi,
> It looks like you configured Database Mail, a new feature in SQL Server
> 2005, but are trying to send e-mail using xp_sendmail, a stored procedure
> that uses SQL Mail, which is a different SQL Server feature. Use
> sp_send_dbmail instead. Look BOL for more details and examples.
> Make sure you really configured Database Mail, right-click Database Mail a=nd
> select 'Send Test E-mail' to test that it works.
> By the way, SQL Mail, according to BOL, will be removed in a future versio=n
> of SQL Server.
> Hope this helps,
> Ben Nevarez
>
> "mohit" wrote:
> > Hi All,
> > =A0 =A0 =A0 =A0I am using SQL SERVER 2005 Standard Edition. I have enabl=ed
> > database mail from Surface Area Configuration and also configured
> > database mail from Object Explorer ->management.
> > =A0 =A0 =A0 =A0When i am trying to send mail by using extended stored
> > procedure xp_sendmail i am getting error as follows:
> > =A0 =A0 xp_sendmail: Procedure expects parameter @.user, which was not
> > supplied.
> > =A0 =A0 =A0It will be a great help if you guys can help me.
> > =A0 =A0 =A0Thanks in advance.- Hide quoted text -
> - Show quoted text -
Hi,
Thanks a lot. It helped me a lot.

No comments:

Post a Comment