Finally found a hint online that shows the extra setting you need to exec linkedServerName.dbName.owner.storedProc

Until now, I get "server not configured for RPC". Turns out, you need to turn ON RPC OUT

syntax:
EXEC sp_serveroption 'linked_server_name', 'rpc out', 'true'

(or use the Ent Mgr UI, right click properties on the linked server)

Google Groups: View Thread "Executing sp of another Server"

Posted 4:17 PM    |    0 comments    |    Permalink