Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2012-06-25 : 19:06:21
|
Almost all of my stored procs contain this...SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGO But I got a warning from some monitoring software I recently installed (Quest Foglight) that states that inclusion of these "SET" statements can cause recompiles.This confirms it...http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspxComments? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SET causing recompiles?