#linked server error

SQL Server: Discuss Execute(SQL) At LinkedServer

Introduction I recently end up in calling a remote stored procedure(“X”) from a remote machine (“Y”)and  the script needed to pull data store it on a remote server(“Z”).  I set up the linked server and everything was working great. Executing queries to pull the data to my machine was fine, but a problem arose when I needed to execute a stored procedure from the other server. The three methods…