Generated SQL: ANSI NULLS : SET TO OFF BY DEFAULT

Hi,

By default .nettiers generates all stored procedures with ANSI NULLS set to OFF. e.g SET ANSI_NULLS OFF

We are using a SQL Server 2005 Indexed View, which must use  SET ANSI_NULLS ON for any CRUD operations.

I understand that using ANSI_NULLS OFF specifies SQL-92 compliant behavior of the Equals (=) and Not Equal to (<>) comparison operators when used with null values.

I was wondering if there was a specific reason (apart from the above) why the generated stored procs are using SET ANSI_NULLS OFF, and if there are any known issues/conflicts if we were to change the base generation code to out stored procs with SET ANSI_NULLS ON.

Any help/information would very much appricated.

Thanks in advance.

 We use ANSI NULLS ON with no problems.

hth

swin

Dido what swin said.

jeff