Friday, March 13, 2015

SQL store procedure Execution plan

SET SHOWPLAN_ALL ON




GO






-- FMTONLY will not exec stored proc


SET FMTONLY ON




GO



exec [dbo].[proc_CompleteTimerRunningJob]




GO



SET FMTONLY OFF




GO



SET SHOWPLAN_ALL OFF




GO

No comments:

Post a Comment