FIX: AV from View with Group By and Incorrect Column List

MORE INFORMATION

SQL Server should not create a view which has more columns in the view's list than are created by the view's SELECT statement. SQL Server should generate the following error message:

However, if there is an extra name in the view's column list, SQL Server may create the view without generating the 4502 error. When a user then attempts to perform a SELECT against this incorrect view, he or she will generate a thread level access violation in SQL Server.