access database on other server

[iccsi]

I would like to know can I use stroed procedures to access database on other server.

I know that I can use 2 dots to access other database on the same server.
I just wanted to know is it possible to access a database on the other server like following:

Select * from //MyDatabaseServer/MyOtherDatabase..MyTable

Your help and information is great appreciated,



iccsi

[Bob Barrows]

Post by iccsi
I would like to know can I use stroed procedures to access database on other server.
I know that I can use 2 dots to access other database on the same server.
I just wanted to know is it possible to access a database on the
Select * from //MyDatabaseServer/MyOtherDatabase..MyTable
Your help and information is great appreciated,

You'll need to set up and use a linked server. There's plenty of info about
this in books online.

Optionally, if the data you want to access does not change very often, you
can create and schedule an SSIS package to periodically bring the data into
the local server.

[iccsi]

iccsi wrote: > I would like to know can I use stroed procedures to access database > on other server. > > I know that I can use 2 dots to access other database on the same > server. > I just wanted to know is it possible to access a database on the > other server like following: > > Select * from //MyDatabaseServer/MyOtherDatabase..MyTable > > Your help and information is great appreciated, > > You'll need to set up and use a linked server. There's plenty of info about this in books online. Optionally, if the data you want to access does not change very often, you can create and schedule an SSIS package to periodically bring the data into the local server.

Thanks for the message,
I do not see Linked Servers on Object Explorer when I right click.
Does it mean that I do not have rights to create linked server?

Thanks again,

iccsi

[Bob Barrows]

Post by iccsi

iccsi wrote: > I would like to know can I use stroed procedures to
access database > on other server. > > I know that I can use 2 dots
to access other database on the same > server. > I just wanted to
know is it possible to access a database on the > other server like
following: > > Select * from
//MyDatabaseServer/MyOtherDatabase..MyTable > > Your help and
information is great appreciated, > > You'll need to set up and use
a linked server. There's plenty of info about this in books online.
Optionally, if the data you want to access does not change very
often, you can create and schedule an SSIS package to periodically
bring the data into the local server.

Thanks for the message,
I do not see Linked Servers on Object Explorer when I right click.
Does it mean that I do not have rights to create linked server?

It's under Server Objects. Be sure to read about them in books online

[iccsi]

iccsi wrote: > On Friday, September 7, 2012 12:32:52 PM UTC-4, Bob Barrows wrote: >> iccsi wrote: > I would like to know can I use stroed procedures to >> access database > on other server. > > I know that I can use 2 dots >> to access other database on the same > server. > I just wanted to >> know is it possible to access a database on the > other server like >> following: > > Select * from >> //MyDatabaseServer/MyOtherDatabase..MyTable > > Your help and >> information is great appreciated, > > You'll need to set up and use >> a linked server. There's plenty of info about this in books online. >> Optionally, if the data you want to access does not change very >> often, you can create and schedule an SSIS package to periodically >> bring the data into the local server. > > Thanks for the message, > I do not see Linked Servers on Object Explorer when I right click. > Does it mean that I do not have rights to create linked server? > It's under Server Objects. Be sure to read about them in books online

Yes, I right click on server object, but I can not see Linked Servers option.
I might try another server and SSMS to see what happen.
Thanks again,


iccsi

[iccsi]

iccsi wrote: > On Friday, September 7, 2012 12:32:52 PM UTC-4, Bob Barrows wrote: >> iccsi wrote: > I would like to know can I use stroed procedures to >> access database > on other server. > > I know that I can use 2 dots >> to access other database on the same > server. > I just wanted to >> know is it possible to access a database on the > other server like >> following: > > Select * from >> //MyDatabaseServer/MyOtherDatabase..MyTable > > Your help and >> information is great appreciated, > > You'll need to set up and use >> a linked server. There's plenty of info about this in books online. >> Optionally, if the data you want to access does not change very >> often, you can create and schedule an SSIS package to periodically >> bring the data into the local server. > > Thanks for the message, > I do not see Linked Servers on Object Explorer when I right click. > Does it mean that I do not have rights to create linked server? > It's under Server Objects. Be sure to read about them in books online

Thanks, I undestand now, it must be done on the server machine.

Thanks,

iccsi

[iccsi]

iccsi wrote: > On Friday, September 7, 2012 12:32:52 PM UTC-4, Bob Barrows wrote: >> iccsi wrote: > I would like to know can I use stroed procedures to >> access database > on other server. > > I know that I can use 2 dots >> to access other database on the same > server. > I just wanted to >> know is it possible to access a database on the > other server like >> following: > > Select * from >> //MyDatabaseServer/MyOtherDatabase..MyTable > > Your help and >> information is great appreciated, > > You'll need to set up and use >> a linked server. There's plenty of info about this in books online. >> Optionally, if the data you want to access does not change very >> often, you can create and schedule an SSIS package to periodically >> bring the data into the local server. > > Thanks for the message, > I do not see Linked Servers on Object Explorer when I right click. > Does it mean that I do not have rights to create linked server? > It's under Server Objects. Be sure to read about them in books online

founded it, thanks a million,

iccsi