in the example I'm using, my linked server is called DSSQL.

SELECT * FROM [DSSQL].[master].[sys].[objects] WHERE TYPE='P';