How to find whether a stored procedure exists on a linked server?

Question

I want to check whether a stored procedure exists on a linked server.

Answer 1

SELECT *
FROM OPENQUERY(
    [DBMSSQL\MSSQL2008R2], 
    'select * from [db1].sys.objects where type=''P'' and name=''procedure1'''
)