Re: reference a database in SP
From: Ben Amada (ben_at_REpoMOweVErpick.com)
Date: 02/22/04
- Next message: Roji. P. Thomas: "Re: Variable list of values in column"
- Previous message: Uri Dimant: "Re: select column if"
- In reply to: Ben Amada: "Re: reference a database in SP"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 22 Feb 2004 02:00:41 -0700
Ben Amada wrote:
> I haven't used these before, but try looking up the following 2 keywords
> in Books Online:
>
> OPENROWSET
> OPENDATASOURCE
>
> These are alternatives to using linked servers.
>
> Ben
Actually, these might not work, because in the Remarks section of these
commands in Books Online, the following is stated:
"OPENROWSET/OPENDATASOURCE can be used to access remote data from OLE DB
data sources only if the DisallowAdhocAccess registry option is explicitly
set to 0. When this option is not set, the default behavior does not allow
ad hoc access."
Most likely, this registry value has not been explicitly set to 0. You can
still try though ...
Ben
- Next message: Roji. P. Thomas: "Re: Variable list of values in column"
- Previous message: Uri Dimant: "Re: select column if"
- In reply to: Ben Amada: "Re: reference a database in SP"
- Messages sorted by: [ date ] [ thread ]
