Search code examples
sqllinked-server

SQL 2008 R2 SP2 Linked Server - Exclude certain databases


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?


Solution

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