Category: SQL Server

SQL Server Error Code – 21540 you cannot drop a column defined as data

In this blog post, you’ll learn more about the SQL Server Error Code 21540 and the error message description that is shown SQL Server Error Code 21540 SQL Server Error Description for the Code :21540 You cannot drop a column defined as data type uniqueidentifier with the rowguidcol property because merge replication uses this column for tracking. To drop the column, you must first drop…

SQL Server Error Code – 21650 the value specified for @rowcount_only f

In this blog post, you’ll learn more about the SQL Server Error Code 21650 and the error message description that is shown SQL Server Error Code 21650 SQL Server Error Description for the Code :21650 The value specified for @rowcount_only for the article ‘%s’ is not 1. For an article in a publication from a non-SQL Server Publisher, 1 is the only valid setting for…

SQL Server Error Code – 9340 %sexplicit import of the current target

In this blog post, you’ll learn more about the SQL Server Error Code 9340 and the error message description that is shown SQL Server Error Code 9340 SQL Server Error Description for the Code :9340 %sExplicit import of the current target namespace is invalid. References to items in the current target namespace that have already been loaded in the schema collection will be resolved implicitly.

SQL Server Error Code – 35351 drop index statement failed because a co

In this blog post, you’ll learn more about the SQL Server Error Code 35351 and the error message description that is shown SQL Server Error Code 35351 SQL Server Error Description for the Code :35351 DROP INDEX statement failed because a columnstore index on a partitioned table must be partition-aligned with the base table (heap). Consider dropping the columnstore index before dropping a clustered index.