SQL Server Error Code – 10126 cannot create %s_msg on view “%.*ls” bec
In this blog post, you’ll learn more about the SQL Server Error Code 10126 and the error message description that is shown
SQL Server Error Code
10126
SQL Server Error Description for the Code :10126
Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.
Leave Your Comment