You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Execute stored procedure from SQR

No replies
Guest's picture

I have a stored procedure that must do insert on link server, I have the following code that execute the stored procedure:

Begin-SQL On-Error=SQL-Error
EXECUTE SP_JDEEmployee $Emplid $Name $JDE-Julian

I get the following error on executing the SQR

SQL Status = 16954, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no cursor.