ziangij (4/6/2010)
Thanks for the question, Paul. Luckily, I have setANSI_NULLS ONon my servers..:-)
Good stuff.
If you would like to check that no-one else has manually created a procedure, function, trigger, or view and overridden your default settings at the session level, run the script I posted before - just to check 🙂