Monday, March 26, 2012

Link Server questions

I create a link server from one SQL Server to another.
Why do I only see a couple of objects, mainly from one
database? I need to also see objects from other
databases. Please help.
TIA,
VicThe reason you only see a limited number of objects is because you connect
to the linked server using permissions granted to the user that is
connecting to the linked server and object in the default database for the
user.
Jim
"Vic" <vduran@.specpro-inc.com> wrote in message
news:05d701c3d568$2ed76910$a101280a@.phx.gbl...
> I create a link server from one SQL Server to another.
> Why do I only see a couple of objects, mainly from one
> database? I need to also see objects from other
> databases. Please help.
> TIA,
> Vic

No comments:

Post a Comment