>IIRC the fully qualified name of a table is
>server.database.schema.tablename. I have never tried to do this, but I
>believe it is possible to create joins form very disparate sources. I
>imagine it would look something like this:
>
>SELECT
>fields
>FROM
> aServer.oneDatabase.dbo.whatEverTable INNER JOIN
> anotherServer.secondDatabse.someSchema.relatedTable ON
> fieldOfFirstTable = fieldOfSecondTable
>
>This is probably not a very practical solution. I believe allot of setup
>would be required in that the MS SQL Servers would need to somehow see
>each other or know how to access each other. Performance would probably
>be very dicey. But I remember reading somewhere about this theoretical
>capability.
>
I'm actually doing this now.
but instead of the using the full server name I'm using the ".." shortcut
to go access the same server but different database.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
