Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Indexed views

Status
Not open for further replies.

davida37

IS-IT--Management
May 10, 2006
113
GB
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:
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top