Right now.. the databases on on the same server, same instance. Does anybody have any example syntax? I'm working on it now but I've never had to do a join like this so I'm still trying to figure out who to lay it all out.
On Wed, Nov 10, 2010 at 2:06 PM, Matthew Woodward <[email protected]>wrote: > On Wed, Nov 10, 2010 at 12:02 PM, Carl Von Stetten < > [email protected]> wrote: > >> +1 on the link Matthew sent. If the databases are on two different >> servers (or two different instances of SQL Server on the same box), you'll >> need to create a linked server on one of the servers to connect to the other >> one. >> > > Right--good point, and bear in mind this is something I haven't had to do > in about 5 years. But you don't create datasources to both databases. You > just point to one, and on that server you do whatever is necessary to let > you refer to the other database within your SQL. At least that's my > recollection. > > -- > Matthew Woodward > [email protected] > http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html > > -- > Open BlueDragon Public Mailing List > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon > official manual: http://www.openbluedragon.org/manual/ > Ready2Run CFML http://www.openbluedragon.org/openbdjam/ > > mailing list - http://groups.google.com/group/openbd?hl=en > -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
