If you are going to repeatedly use the remote server through stored procedures and queries, it is better to set up that server as a linked server.  Creating a linked...

I think Brian has the right approach, but for a different reason.  Part of the process of an upgrade is the testing that MUST occur for all of your applications...