SQL Server Performance

SQL-92 Settings for Stored Procs

Discussion in 'T-SQL Performance Tuning for Developers' started by KeiserSoze, Oct 28, 2004.

  1. KeiserSoze New Member

    I am looking for some information on where to set the SQL-92 Settings Statements and why. I have seen the statements, such as "SET ANSI_DEFAULTS ON" or "SET ANSI_NULLS ON", set before the drop of a procedure, before the create procedure command and inside the proc itself. It seems the proc behaves differently depending on where these settings are made. I have not been able to find the final word from Microsoft on this. I know a number of these settings cause the proc to recompile but does it matter if it is outside or inside the proc?

    If the settings are before the create procedure command then how does the proc know to follow these settings when the proc is called from an app?

    Thanks
  2. FrankKalis Moderator

Share This Page