... and use a four-part naming convention.

Quoting Swasey Steve D CTR 554 ELSG/FNF
<mssqldba-ezmlmshield-x70449308.[Email address protected]

> Marty:
>
> If I understand you right, you want to create a query that uses tables
> on different servers?
>
> That shouldn't be any problem. Just create linked servers and you can
> then create a query on one server that "queries" any of its linked
> servers.
>
> Steve
>
>
> -----Original Message-----
> From: Marty Galvan
> [mailto:mssqldba-ezmlmshield-x20370228.[Email address protected]
> Sent: Monday, February 26, 2007 3:46 PM
> To: LazyDBA Discussion
> Subject: Inner joining different servers
>
> Is it possible to inner join servers on a query? I want to check one
> server that is used for web orders to make sure they are getting
> imported into our business system. I want to write a query and do a
> check to see if they got moved over. Is this possible?
>
> Thanks,
>
> Marty Galvan
> DB/EDI Admin
> Making Memories
> [Email address protected] <mailto:[Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>




MS Sql Server LazyDBA home page