Sample Header Ad - 728x90

Unable to view linked server tables list in SSMS object explorer

0 votes
1 answer
264 views
I'm using SQL2022 I have a linked server to another SQL server, security is set with a defined username/password. My issue is that when logged into the server with a standard account I cannot see a list of the tables/views on my linked server within the object explorer. I can query the linked server just fine, but cannot expand the tables tree to see what tables are available. If I log into the server with my SA account, I can expand the tree and see all the tables and views on the linked server. What permission do I need to set on my standard login to be able to view the tables in the object explorer.
Asked by Matt (101 rep)
Aug 20, 2024, 12:54 AM
Last activity: Jun 16, 2025, 07:04 PM