Tables in Muliple Servers

[Swish]

What is the best way to use a table located on 1 server on another
server. We have an application that needs to use data from 2 separate
servers. TIA.

TS

[Simon Hayes]

"Swish" <ts******@gfnet.com> wrote in message
news:42**************************@posting.google.c om...

What is the best way to use a table located on 1 server on another
server. We have an application that needs to use data from 2 separate
servers. TIA.

TS

It depends on exactly what you need to do, but you should probably look into
"linked servers". That would allow you to refer to a table like this:

select * from AnotherServer.Database.dbo.Table

There's lots of information in Books Online on this.

Simon

[David Penney]

Linked MS-SQLServers for small low end requirements - the MetaMatrix Server
for more complexity, high performance & efficiency.

Regards
David Penney (MetaMatrix)
http://www.metamatrix.com
"Swish" <ts******@gfnet.com> wrote in message
news:42**************************@posting.google.c om...

What is the best way to use a table located on 1 server on another
server. We have an application that needs to use data from 2 separate
servers. TIA.

TS