Other than creating a remote server on each box, what steps do I need to take to be able to execute a stored proc on a 6.5 box to retrieve data from the 7.0 server. (I know upgrade the 6.5 box would be sensible but that's not an option just yet)
7.0 onwards allows you to prefix an object with server.dbname.owner whereas 6.5 only allows dbname.owner. How do you specify the server?
Many thanks for any hints, tips, ideas, complete coded solutions :-) etc.