Re: Index on a view and ANSI_NULLS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 12:56:27 -0400

It's not a property per say that you can turn on or off. It is meta data
that is stored with the object at create time. As such you need to drop and
recreate the table with the proper environment set. Obviously you would
want to export your data first. 

-- 
Andrew J. Kelly  SQL MVP
"Steven Yampolsky" <syampolsky@eagleinvsys.com> wrote in message
news:uGI9e90aEHA.3792@TK2MSFTNGP09.phx.gbl...
> I was trying to create an index on a view and realized that some of the
> underlying tables where creates with ANSI_NULLS set to OFF.
>
> Is there a programatic(t-sql) way to turn ansi_nulls on on a table?
>
> Steven Yampolsky
>
>