ANSI SETTINGS AND INDEXED VIEWS GO HAND IN HAND

ANSI settings can be set at different points within SQL Server. They 
are
maintained at the server, database, connection settings, and session
level using the SET statement. The order of precedence from highest to
lowest is top to bottom, respectively:


* Session using the SET command

* OLE DB and ODBC connection options

* Database default settings

* Server default settings


For indexed views to be consistent with data results, a defined set of
ANSI settings is required. This applies to any connection issuing 
commands
to update, delete, or insert data or to create indexes for indexed
views. The following are the required ANSI settings for indexed views.

The ANSI settings set to ON are:


* ANSI_NULLS

* ANSI_PADDING

* ANSI_WARNING

* ARITHABORT

* CONCAT_NULL_YIELDS_NULL

* QUOTED_IDENTIFIER


The ANSI settings set to OFF are:


* NUMERIC_ROUNDABORT


The ANSI settings are set to three other categories by default. 
However,
none of these categories match the required settings for indexed views.
The three categories are:


* Default server settings

* OLE Db and ODBC settings

* DB LIB settings


----------------------------------------

CORRECTION

Please note that there was an error in the tip, "Zero in on tables
without indexes" (April 16, 2002). The final sentence should read:

Using the same query, you can substitute the 'TableHasIndex' property
with the 'TableHasClustIndex' property to find tables that do not have 
a
clustered index.

We apologize for an inconvenience this may have caused.

----------------------------------------