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

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance