I want to check whether a stored procedure exists on a linked server.
SELECT * FROM OPENQUERY( [DBMSSQL\MSSQL2008R2], 'select * from [db1].sys.objects where type=''P'' and name=''procedure1''' )