sql server2000, i need help with "xp_sendmail" 1

[tempo1]

Hi everyone,
i run the following code (xp_sendmail)

CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_sendmail 'robertk', 
    @query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab

And any way i run it i get the same error message:

xp_sendmail: Procedure expects parameter @user, which was not supplied.

Anyone can tell me hw to supply that "@user" missing parameter and what is it ?
thanks

 

[klewis10367]

You need to add @recipients='robertk', after the xp_sendmail

 

[tempo1]

Hi klewis 10367,
Thanks,
I ran the code as you suggested

CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
DECLARE @recipients varchar(20)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_sendmail @recipients='robertk', 
    @query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab

But unluckily for me, the same error message show up again...
Thanks

 

[SQLDenis]

The error message indicates that you don't have an outlook profile setup which xp_sendmail uses

Google setting up mail in SQL server 2000

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[tempo1]

Thanks a lot Denis