And a caveat on *that* (while we're doing a SQL Server tutorial) is that under some circumstances joins to tables on linked servers are done by issuing a prepared statement (i.e. stored procedure) against the remote table for *every row* in the local table, which obviously scales like...well, something that doesn't scale.
Jaime On Wed, Nov 26, 2008 at 12:28 AM, Dan O'Keefe <[EMAIL PROTECTED]> wrote: > Caveats: >> The databases have to be on the same physical server (or accessible >> using this dot notation from query analyzer anyway) > > > I believe you can overcome this limitation by configuring a linked server, > so you can then > prepend the server name as in: linkedServerName. > dbName.schemaName.tableName > > Dan > > > > --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
