CODEWITHSUNDEEP
sqlsql-serverkentico
Scott L
Scott L

Reputation: 667

Hint 'noexpand' on object 'View_CMS_Tree_Joined'

I'm about to try an upgrade from Kentico 9 to 10. I had to change a column from varchar to nvarchar.

To do this I had to update an index so it didn't use the column and then remove a view, then added the view back in after I updated the column, then updated the index again

Now when I go onto the site I get this error:

Hint 'noexpand' on object 'View_CMS_Tree_Joined' is invalid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Hint 'noexpand' on object 'View_CMS_Tree_Joined' is invalid.

How do I fix this so I can start the upgrade?

Thanks

Upvotes: 0

Views: 2978

Answers (1)

Scott L
Scott L

Reputation: 667

I was missing an index for the view, I thought that right clicking > script view as > create to new query editor window would give me the code to recreate the view and it's indexes but it only created one of the two indexes.

Upvotes: 3

Related Questions