Show execution plan for stored procdure

SET SHOWPLAN_ALL ON
GO

-- FMTONLY will not exec stored proc

SET FMTONLY ON
GO

exec SampleStoredProcedure

GO

SET FMTONLY OFF
GO

SET SHOWPLAN_ALL OFF
GO