How to send emails from SQL server 2000

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 2000 Forums

SQL Server Development (2000)

How to send emails from SQL server 2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-28 : 07:34:03

Nagaveni writes "Hi,

I have my database in SQL server 2000 having windows 2000 advanced server as OS.I am using Microsoft outlook as a mail client.

I have written a stored procedure by name "autoemail"
for sending mails from sql server 2000.

1.when i execute this procedure as
exec autoemail
"The following error is encountered"

Server: Msg 17985, Level 16, State 1, Line 0
xp_sendmail: Procedure expects parameter @user, which was not supplied.

2.when i execute by giving parameters for xp_sendmail
as
exec xp_sendmail @recipients='nagaveni.ramaiah@wipro.com'

The following error is encountered

Server: Msg 17985, Level 16, State 1, Line 0
xp_sendmail: Procedure expects parameter @user, which was not supplied.

could any suggest me how to proceed.

Thanx in advance.

Regards,
veni"

nr
SQLTeam MVY

12543 Posts

Posted - 2004-09-28 : 07:37:21

Try
exec master..xp_sendmail @recipients='nagaveni.ramaiah@wipro.com'

Sounds like someone has written another version in your database.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

X002548
Not Just a Number

15586 Posts

Posted - 2004-09-28 : 09:14:36

I'm wondering if it could be a trigger on a system table....

Brett

8-)

rajendraprasad_t
Starting Member

1 Post

Posted - 2004-10-26 : 05:30:00

Inorder to avoid this error we must configure the SQL Mail in sqlserver. Once this is configured this error will not occur again.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources