SQL Server Error Msg 8663 – Cannot create the clustered index “%.*ls” on view “%.*ls” because its select list does not include COUNT_BIG(*). Consider adding COUNT_BIG(*) to the select list.

In this blog post, let’s learn about the error message “8663 – Cannot create the clustered index “%.*ls” on view “%.*ls” because its select list does not include COUNT_BIG(*). Consider adding COUNT_BIG(*) to the select list.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

8663 – Cannot create the clustered index “%.*ls” on view “%.*ls” because its select list does not include COUNT_BIG(*). Consider adding COUNT_BIG(*) to the select list.

Reason for the Error

To be update soon…

Solution

To be update soon…