>Hi guys...
>
>I am just posting a query from a friend and unfortunately my stocked knowledge doesn't have the answer to his question and i don't have the time to look it up for him...so i thought i'd quickly run to my reliable source of programming support...:) How do you access objects (i.e. Stored procedures, tables, etc) from two different sql server instances? also, let me just add...how do you process/create a connection from a sql server database to an external database/server (i.e. access, mysql)? thanks guys...got to rush!

In answer to both questions see 'linked servers' in the index of BOL.