Ravid_ds (1/3/2014)
You can test by mentioning SET STATISTICS ON/OFF while executing the SP.
Oh be careful now. SET STATISTICS is a known liar when it comes to certain forms of code. Please see the following article for proof of that.
http://www.sqlservercentral.com/articles/T-SQL/91724/
--Jeff Moden
Change is inevitable... Change for the better is not.