Collate clause may not be used in an indexed view.

The COLLATE clause appears within the definition of an indexed view, but an indexed view definition cannot contain the COLLATE clause. Modify the view definition by either removing the COLLATE clause or removing the indexes from the view.

Community Additions