April 24, 2009 at 5:05 pm
i am trying to execute a stored procedure from a linked server but i get this error:
Server 'servername' is not configured for RPC.
i know i can enable the RPC option for the servername but is a production server and i can't do that, is there something else i can use/do to be able to execute this stored procedure from a linked server?
April 25, 2009 at 5:27 pm
Hey...
Only other way I can think of doing this is if you bring the store proc over to the other side; and link the tables over... I think.
Mohit
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply