I had tested the remote server (DM to Reporting server)(hub-sub) servers are same versions

Created a synonym it worked

I wanted to execute a remote focus fex as i was reading the documention

Below is what i found

Syntax: How to Execute a Stored Procedure Using Distributed Execution
You can execute stored procedures by issuing the command:

SQL EDA EX rpcnameparm1, parm2, ...
END
where:

rpcname
Is a procedure on the server.

parm1, parm2,...



But it does not have connection information

when run this

SQL EDA EX rpcname
END

its referencing how to set the connection information

sample code or any thing will help

This message has been edited. Last edited by: FOCUS393,

Yup got it it goes something like this

ENGINE EDA SET DEFAULT_CONNECTION NODENAME

SQL EDA EX PROCEDURENAME

END