On one of the projects I am working we got around the cross database issue by creating a set of views on the primary database that simply does a select against the the table in another database using the dot notation that Jared mentioned. This has worked well so far. Note this is SQL Server 2005 we are using.
--Kurt On Tue, Nov 25, 2008 at 8: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 -~----------~----~----~----~------~----~------~--~---
