14,494 questions
I expected to see too Programmability folder and within it the Stored procedures and functions
You always sees only tables & views, but never any kind of other objects like procedures.
Missing Stored Procedures in Linked Server view within SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 73%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Talal Hallaj
20
Reputation points
Why am I unable to see Stored Procedures or functions when I open a Linked Server in SSMS? I have created the Linked Server and can see the databases, but within each database, only tables and views are shown.
The Linked Server is connected to another SQL Server instance installed on another Server, I expected to see too Programmability folder and within it the Stored procedures and functions
SQL Server Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-06-05T06:32:56.0766667+00:00 Hi @Talal Hallaj
I think Olaf's and Erland's suggestions are very useful. Did these answers help you? If the answer is useful, please click
Accept Answerto let others with similar questions quickly find answers. If you have any questions, please feel free to let us know.Best regards,
Aniya
Sign in to comment
Accepted answer
-
Olaf Helper 47,436 Reputation points2023-06-02T07:42:37.6466667+00:00 -
Talal Hallaj 20 Reputation points
2023-06-06T07:21:40.2766667+00:00 I accidentally pressed a button Olaf's Accept answer
I wanted to accept his answer
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-06-02T07:48:30.9633333+00:00 Because tables ad view is all that is exposed. Keep in mind that a linked server can be any data source, it does not have to be another SQL Server instance. Therefore, you can only see things that can be expected from any data source. Far from all data sources have stored procedures.
The simplest would be to connect to the remote instance, but you can also run queries against the system catalog, for isntance
SELECT * FROM SERVER.db.sys.procedures.