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)
 SQL-Mail always sends 2 equal mails...

Author  Topic 

cecilius
Starting Member

19 Posts

Posted - 2000-09-29 : 01:18:33
My procedure is looking like this :

CREATE PROCEDURE Requestmail
(@mail1 varchar(50), @Userok varchar(50), @Pwok varchar(50))
AS
exec master..xp_sendmail @recipients=@mail1, @subject='Hier ist Ihr Username :', @message=@Userok


The problem is, that SQL-Mail sends this message always two times and both complete equal.

And how can i put multiple variables, like @Userok AND @PWok in the message-Body?

Greetz and thanks a lot

   

- Advertisement -