LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Parts/Attachments: text/plain (18 lines)
Print Reply
Content-Transfer-Encoding:
quoted-printable
Sender:
LISTSERV give-and-take forum <[log in to unmask]>
Subject:
From:
"Johan Kronberg (n3sport)" <[log in to unmask]>
Date:
Tue, 6 May 2003 15:48:57 +0200
Content-Type:
text/plain; charset="us-ascii"
MIME-Version:
1.0
Reply-To:
LISTSERV give-and-take forum <[log in to unmask]>
Hi again.

I've now successfully tested my DISTRIBUTE MAIL-MERGE DBMS=YES...

But when I put the exact same SELECT-statement in a stored procedure and
replace it with
"EXEC n3admin.dbo.TLS_getPersonnelAllForSite 38" in my command mail I
get the return msg "Distribution aborted - no valid recipient." even
though I've tested that the stored procedure returns the exact same
resultset as the previous SELECT-statement when running it with my
listserv sql server-user.

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

Regards,
Johan

ATOM RSS1 RSS2