Select * From sysobjects Where name = 'MyProcedureName'
declare @procname sysname = 'MyProcedureName' exec @procname