Post reply

Shows Object Views error HINT No Expand

  • September 6, 2010 at 4:12 am

    #226532

    Hint 'noexpand' on object 'database_name.dbo.Presentation_View' is invalid. Could not use view or function 'objectviews.dbo.productpresentationview' because of binding errors.

    Can anyone please reply ?

    Thanks in advance

  • November 23, 2010 at 2:32 pm

    #1254754

    Hi,

    This error message occurs when you try to use a view that does not have an index. Re-create the clustered index on the view and you'll be fine.

    KR,

    Jos

  • November 1, 2013 at 3:34 am

    #1663367

    Perfect thanks had this issue too now fixed. I think a developer must have dropped it and not recreated it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply