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