Hi Burcht!
I am not familiar with MS SQL-Server. Maybe you should post that question in an MS-SQL Server forum or at least start a new thread, so everybody will read your request.
In MS-Access you can define a database link to external databases and reference that just like an access-table. Maybe there is such kind of functionality in MS-SQL Server too, but thats just a guess.