Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 email

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2007-12-18 : 04:55:49
EXEC master.dbo.xp_sendmail
@recipients=N'myemailaddress@somewhere.com',
@message=N'job failed.' ;

Do you know why the following error is produced?
xp_sendmail: Procedure expects parameter @user, which was not supplied.

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-18 : 05:24:58
Did you supply the wanted parameter @user?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2007-12-18 : 05:50:59
Not sure which user it is requiring?
something like sa ?
Thanks
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-18 : 21:29:02
Yes, whoever send the mail.
Go to Top of Page
   

- Advertisement -