Set Ansi Nulls Off?

[Greg.NET]

when I set ansi nulls off does it stay off until its explicitly set to ON or does it only stay off for the duration of the query?

 

[Greg.NET]

i guess I asked a stupid question because nobody is answering

 

[cjard]

http://www.sqlmag.com/articles/index.cfm?articleid=7635&

Why do you need to set it anyway? Whats wrong with using "IS NULL" (i.e. the proper way) as your comparator?

 

[sikunj]

SET ANSI NULLS OFF
GO
CREATE PROCEDURE <name>
Go
The effect of ansi null vanishes here