Hi Rodrigo,

If you want to index a view in SQL Server, there are some requirements that need to be met.

See "Creating an Indexed View" in Books Online for more information.

John

-----Original Message-----
From: José Rodrigo [mailto:[Email Address Removed]
Sent: Monday, March 29, 2004 1: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


MS Sql Server LazyDBA home page