SQL 2008 R2 SP2 Linked Server - Exclude certain databases

Question

I have a linked server and I would like to exclude 4 databases in the link. Is there a way to "hide" them? Currently the users access via the AD groups they are in. Would I just revoke the AD groups?

You should be able to achieve this by revoking access on the linked server to these AD groups. — SchmitzIT, Oct 06 '14 at 16:31

score 0 · Accepted Answer · answered Oct 06 '14 at 18:15

0

I set the databases offline and they disappeared from the linked view. These were there for reference only, so it made sense.

answered Oct 06 '14 at 18:15

Mochael_DLite

167
2
5
14

SQL 2008 R2 SP2 Linked Server - Exclude certain databases

1 Answers1