Advanced Search

To make an SP Recompile

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. recompile the keep the sp IN compiled format FOR better performance.
  2. 	UPDATE STATISTICS PriceListTable
  3. 	DBCC UPDATEUSAGE (0, "PriceListTable")
  4. 	EXEC sp_recompile PriceListTable

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.