Excerpt from BOL: Creating An Indexed View:
---------------------------------------------------------------------------T
he CREATE INDEX statement must meet these requirements in addition to the
normal CREATE INDEX requirements:

The user executing the CREATE INDEX statement must be the view owner.

These SET options must be set to ON when the CREATE INDEX statement is
executed:
ANSI_NULLS
ANSI_PADDING
ANSI_WARNINGS
ARITHABORT
CONCAT_NULL_YIELDS_NULL
QUOTED_IDENTIFIERS
The NUMERIC_ROUNDABORT option must be set to OFF.

The view cannot include text, ntext, or image columns, even if they are not
referenced in the CREATE INDEX statement.

If the SELECT statement in the view definition specifies a GROUP BY clause,
the key of the unique clustered index can reference only columns specified
in the GROUP BY clause.
---------------------------------------------------------------------------


-----Original Message-----
From: =?UNKNOWN?Q?Jos=E9?= Rodrigo [mailto:[Email Address Removed]
Sent: Monday, March 29, 2004 3:37 PM
To: LazyDBA.com Discussion
Subject: indexed view

When try make an unique clustered index in an View apper this error
menssage:

Server: Msg 1936, Level 16, State 1, Line 1
Cannot index the view 'db.dbo.VW_Cons'. It contains one or more disallowed
constructs.

Someone see this error? help-me please...

Rodrigo

_________________________________________________________
Voce quer um iGMail protegido contra vírus e spams?
Clique aqui: http://www.igmailseguro.ig.com.br



****************************************************************************
This email may contain confidential material.
If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.
****************************************************************************
MS Sql Server LazyDBA home page