Monday, March 26, 2012

Question Regarding Execution of Stored Procedure on linked server using RPC

When I execute a stored procedure it always works fine using the syntax
EXEC server.db.catalog.stored_proc_name
However whenever I change the stored procedure to have parameters and
attempt to pass the parameters to the stored procedure I receive the
error:
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'stored_proc_name' on remote server
'server'.
Any ideas or suggestions about why this is occurring?
Thanks,
Ed
try using the OPENQUERY Function

No comments:

Post a Comment