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
End-SQL

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.