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.
>

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.

error help:Remote access not allowed for Windows NT user activated by SETUSER

Hi,

I just install SP3 for our SQL Server 2000 yesterday.After that, I have problem using xp_sendmail.
I have a stored procedure in Server A that getting result from Server B.
In Query Analyzer, I can successfully execute procedure A.(exec procedure_name)
However, if I put it in xp_sendmail command...(exec sp_sendmail email_address ,@.query='exec procedure_name'),
I got an error message saying 'ODBC error 7410 (42000) Remote access not allowed for Windows NT user activated by SETUSER.'

But before I upgrade, that xp_sendmail works fine for more than one month.

BTW,if in xp_sendmail, I only get result from local server, it works perfect fine.

How can I make it work?

Thanks in advance.you can put the result of the SP into a global temp table (or permanant one) and select from that in the xp_sendmail.

Don't have 2 sp3 systems here to see what's wrong it but praobably will tomorrow.
Does the profiler show anything interesting?