Everywhere else I use ODBC It's possible to execute a SP.

Why has this been blocked in ListServ?

For me this a serious problem and seems like a very unnecessary limitation which cripples the whole mail merge function. 

Anyway I haven't done a trace in my SQL Server but I get the msg "Distribution aborted - no valid recipient" which I read as if ListServ actually tries to run the query, or?

Regards,
Johan

-----Ursprungligt meddelande-----
Från: John Traweek [mailto:[log in to unmask]] 
Skickat: den 7 maj 2003 13:50
Till: [log in to unmask]
Ämne: Re: mail merge using stored procedure fails


I know for a fact that I run UPDATE statements all the time, so I know SELECT statements aren't the only T-SQL commands allowed, as for SP's I don't know, never tried it.

John Traweek
Senior Account Director
Publishing Concepts, LP
12840 Hillcrest Rd, Ste 230
Dallas, TX 75230
Phone - 972.774.3280
Fax - 972.448.1622

-----Original Message-----
From: Johan Kronberg (n3sport) [mailto:[log in to unmask]]
Sent: Wednesday, May 07, 2003 2:34 AM
To: [log in to unmask]
Subject: SV: mail merge using stored procedure fails

That is really lame!

Why is it so?

Mustn't there be a way around just SELECT? After all Stored Procedures is the proffesional way to work with a databaseapplication.

Johan

-----Ursprungligt meddelande-----
Från: Francoise Becker [mailto:[log in to unmask]]
Skickat: den 6 maj 2003 20:07
Till: [log in to unmask]
Ämne: Re: mail merge using stored procedure fails


On 6 May 2003, at 15:48, Johan Kronberg (n3sport) wrote:

> How do I run a SQL Server Stored Procedure instead of a regular 
> SELECT-statement?

You can't. Only SELECT statements are allowed.

Francoise