Indexed views

[davida37]

Hello,

I have a view created from a Pivot. I am trying to create an index on this view but get the following error: Cannot create index on view 'testview' because the view is not schema bound.

It is possible to create an index on view which is created from a pivot?

Thanks
David

Here is the full error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Index 'IDX_test'. (Microsoft.SqlServer.Smo)

Cannot create index on view 'testview' because the view is not schema bound. (Microsoft SQL Server, Error: 1939)

For help, click:

http://go.microsoft.com/fwlink?Prod...42&EvtSrc=MSSQLServer&EvtID=1939&LinkId=20476

 

[davida37]

ok... well if I make this schema binding then this cuases a lot of heartache in other areas - i.e. replication. will have to find a work around for this.

thanks