Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp re compile when executing

Status
Not open for further replies.

nirmalsp

MIS
Jan 17, 2002
25
LK
hi

i need to disable sp re-compilation when executing
is it possible. since i have a problem with my sql server
performance.

how could i do it.

need help

Thanks
 

By default stored procs should not recompile unless the underlying tables referenced in the SP are changed or the "With Recompile" option is specified when the SP is compiled or executed. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top