Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

SQL 2005 Linked Servers


Can I just say,

SELECT *
FROM ServerA.DatabaseA.SchemaA.TableA
UNION
SELECT *
FROM ServerB.DatabaseB.SchemaB.TableB

Without explicitly creating a "linked server" ?

--

Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

I am unable to test right now but I imagine that you have two servers handy
hence the question. My first instinct is a no. I am fairly confident in that
no also. Without a linked server you don't have any security context defined
and have not setup any connection method to the second server.

The best answer will come with a quick test. Try it and see the results. It
should not work. Most likely.

"Mike Labosh" <mlabosh_at_hotmail_dot_com> wrote in message

news:eb4VuJxoHHA.596@TK2MSFTNGP06.phx.gbl...

"Mike Labosh" <mlabosh_at_hotmail_dot_com> wrote in news:eb4VuJxoHHA.596
@TK2MSFTNGP06.phx.gbl:

> Can I just say,

> SELECT *
> FROM ServerA.DatabaseA.SchemaA.TableA
> UNION
> SELECT *
> FROM ServerB.DatabaseB.SchemaB.TableB

> Without explicitly creating a "linked server" ?

But see OPENDATASOURCE and OPENROWSET in BOL.

e.g.

SELECT *
FROM OPENDATASOURCE('provider_nameA',
'provider_stringA').DatabaseA.SchemaA.TableA
UNION
SELECT *
FROM OPENDATASOURCE('provider_nameB',
'provider_stringB').DatabaseB.SchemaB.TableB

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc