Edits not allowed. Having clause not allowed in an indexed view.

You cannot use the HAVING clause in the view definition of an indexed view. You can remove the indexes or you can remove the HAVING clause.

See Also

Other Resources

Error Messages in Visual Database Tools