Paul White NZ (4/6/2010)
CirquedeSQLeil (4/6/2010)
Nice question Paul.1. Did you get it right?
2. Are you scared by the behaviour ANSI_NULLS OFF?
Yes I got it correct.
I thought you explained things nicely.
And yes, by having Ansi_Nulls Off, I can see there being complications. I will have to verify this setting on my servers.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events