"Just D." <no@spam.please> wrote in message
news:FkSOc.18891$1o.215@fed1read06...
> Does anybody really know is it possible? We don't want to create a linked
> database, but we need to make some steps on the remote database, gather some
> data and then send this data to our main server via IP connection, setting
> the connection every time when the remote server wants to transfer the data.
> Is it possible at all if we don't create a linked database or whatever, just
> from sql script? If yes, then how?
>
> Dmitri.
>
>

"oj" <nospam_ojngo@home.com> wrote in message
news:ui9sqkzdEHA.4048@TK2MSFTNGP12.phx.gbl...
> You can do ad-hoc/pass through query via openrowset or opendatasource.
> http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_78z8.asp
>
http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_2be1.asp?frame=true
> > Does anybody really know is it possible? We don't want to create a
linked
> > database, but we need to make some steps on the remote database, gather
some
> > data and then send this data to our main server via IP connection,
setting
> > the connection every time when the remote server wants to transfer the
data.
> > Is it possible at all if we don't create a linked database or whatever,
just
> > from sql script? If yes, then how?

"Just D." <no@spam.please> wrote in message
news:xpTOc.19314$1o.15882@fed1read06...
> Thanks for the answer.
>
> "oj" <nospam_ojngo@home.com> wrote in message
> news:ui9sqkzdEHA.4048@TK2MSFTNGP12.phx.gbl...
> > You can do ad-hoc/pass through query via openrowset or opendatasource.
> > http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_78z8.asp
> >
>
http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_2be1.asp?frame=true
> > > Does anybody really know is it possible? We don't want to create a
> linked
> > > database, but we need to make some steps on the remote database,
gather
> some
> > > data and then send this data to our main server via IP connection,
> setting
> > > the connection every time when the remote server wants to transfer the
> data.
> > > Is it possible at all if we don't create a linked database or
whatever,
> just
> > > from sql script? If yes, then how?
>
> Another one idea - if I create ODBC and it's tested and works fine is it
> possible to use that for the same purpose setting a remote database name
via
> ODBC? In other words, is it possible to use a database alias that works
via
> ODBC to set a connection from sql query without a linked database?
>
> Maybe it's easier...
>
> Dmitri.
>
>