Missing Stored Procedures in Linked Server view within SSMS

Talal Hallaj 20 Reputation points
2023-06-02T06:56:28.3833333+00:00

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

2023-06-02 08_51_39-9m9Af.jpg (281×242) - Vivaldi

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,710 questions
Accepted answer
  1. Olaf Helper 40,816 Reputation points
    2023-06-02T07:42:37.6466667+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2023-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.

    1 person found this answer helpful.
    0 comments