Category: SQL Server

SQL Server Error Code – 8678 cannot create the clustered index “%.*ls

In this blog post, you’ll learn more about the SQL Server Error Code 8678 and the error message description that is shown SQL Server Error Code 8678 SQL Server Error Description for the Code :8678 Cannot create the clustered index “%.*ls” on view “%.*ls” because the view references a SUM aggregate of a nullable expression. Consider adding a new COUNT_BIG aggregate over such nullable expression.

SQL Server Error Code – 21390 warning: only subscribers running sql se

In this blog post, you’ll learn more about the SQL Server Error Code 21390 and the error message description that is shown SQL Server Error Code 21390 SQL Server Error Description for the Code :21390 Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because extended properties are scripted out with the article schema creation script.

SQL Server Error Code – 22907 parameter @role_name cannot be empty. sp

In this blog post, you’ll learn more about the SQL Server Error Code 22907 and the error message description that is shown SQL Server Error Code 22907 SQL Server Error Description for the Code :22907 Parameter @role_name cannot be empty. Specify a value for @role_name and retry the operation. Supply null as the value if no role is to be used to gate access to…