We can RECOMPILE a stored procedure in SQL server. Which of the following situations will NOT trigger recompilation of a stored procedure?

 Posted by Bandi on 11/26/2013 | Category: Sql Server Interview questions | Views: 4113 | Points: 40
Select from following answers:
  1. SQL Server is restarted
  2. Using WITH RECOMPILE when calling SP
  3. Underlying table referenced by procedure has undergone physical design changes
  4. Adding a new index from which the procedure might benefit
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response