RE: join two databases

2009-01-16 Thread Dawson, Michael
...@gmail.com] Sent: Friday, January 16, 2009 8:25 AM To: cf-talk Subject: Re: join two databases > You need to link your SQL Server instances. Google "SQL Server Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, yo

RE: join two databases

2009-01-16 Thread Dawson, Michael
ver or the server that is referenced in your datasource. mike -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 8:23 AM To: cf-talk Subject: RE: join two databases Ah.. so there is a way in MS SQL to link two servers together. Then I would just add

RE: join two databases

2009-01-16 Thread Brad Bueche
Message- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Friday, January 16, 2009 9:25 AM To: cf-talk Subject: Re: join two databases > You need to link your SQL Server instances. Google "SQL Server > Linked". > > You can link the servers both directions, i

RE: join two databases

2009-01-16 Thread Brad Bueche
mentioned that "SQL Server Linked" stuff. That's interesting. I'll have to see if that's possible with oracle. brad -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 9:18 AM To: cf-talk Subject: RE: join two database

Re: join two databases

2009-01-16 Thread C. Hatton Humphrey
> You need to link your SQL Server instances. Google "SQL Server Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. Well would ya look at that! Learn something new ever

RE: join two databases

2009-01-16 Thread Chad Gray
. Chad > -Original Message- > From: Dawson, Michael [mailto:m...@evansville.edu] > Sent: Friday, January 16, 2009 9:13 AM > To: cf-talk > Subject: RE: join two databases > > You need to link your SQL Server instances. Google "SQL Server Linked". >

RE: join two databases

2009-01-16 Thread Chad Gray
can you preface the database name with the dns name in CF Admin? Dsn1.database1.dbo.table1? > -Original Message- > From: Duane Boudreau [mailto:du...@sandybaynetworks.com] > Sent: Friday, January 16, 2009 9:09 AM > To: cf-talk > Subject: RE: join two databases > &

RE: join two databases

2009-01-16 Thread Dawson, Michael
You need to link your SQL Server instances. Google "SQL Server Linked". You can link the servers both directions, if needed. With the server linked in SQL, you can create cross-server queries in the Query Analyzer/New Query editor. mike -Original Message- From: Chad Gray [mailto:cg...@

Re: join two databases

2009-01-16 Thread C. Hatton Humphrey
> What is the best way to join tables across two databases servers? > > Say I have one MS SQL server that has a database that stores ERP product > data. I have our website MS SQL server that stores extra data about the > product records in the ERP database. > > Is it possible to hook each dataso

RE: join two databases

2009-01-16 Thread Duane Boudreau
You can reference the database by name in the query Ex: select t1.Field1, t2.Field2, t2.Field3 fromdatabase1.dbo.Table1 t1 inner join database2.dbo.Table2 t2 on t1.Field = t2.Field you might need to put that into a stored procedure or use a dsnless connection -