Click here to Skip to main content
15,886,199 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have to access records from view which resides on another server. So the obvious way to do is by using Linked Server I successfully created it by using
SQL
EXEC sp_addlinkedserver @server = 'Server_Name'


Now I am able to access records from that server using

SQL
SELECT * FROM [Server_Name].[Database_Name].[dbo].[View_Name] 


After creating Linked Server, I am able to view all databases & there resp tables & views under Catalog menu of just created Linked Server. I want to hide all this information under Catalog menu.

How to achieve this? What is the setting to achieve the same.

Thanks in advance.

What I have tried:

I am tried with different versions of sp_addlinkedserver.
I guess setting is made with server from which we have to access record & not with linked server properties.
Posted
Updated 23-Nov-16 2:17am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900