Category: SQL Server

SQL Server Error Code – 35345 merge clause of alter partition statemen

In this blog post, you’ll learn more about the SQL Server Error Code 35345 and the error message description that is shown SQL Server Error Code 35345 SQL Server Error Description for the Code :35345 MERGE clause of ALTER PARTITION statement failed because two partitions on different filegroups cannot be merged if either partition contains columnstore index data. Consider dropping the columnstore index before issuing…

SQL Server Error Code – 29274 component %s reported that the component

In this blog post, you’ll learn more about the SQL Server Error Code 29274 and the error message description that is shown SQL Server Error Code 29274 SQL Server Error Description for the Code :29274 Component %s reported that the component %s in brick %d is in a suspicious state because of the error: %d, severity: %d, state: %d, description: ‘%s’. Additional description provided was:…

SQL Server Error Code – 4819 cannot bulk load. the bulk data stream w

In this blog post, you’ll learn more about the SQL Server Error Code 4819 and the error message description that is shown SQL Server Error Code 4819 SQL Server Error Description for the Code :4819 Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the following…

SQL Server Error Code – 21581 article “%s” in publication “%s” does no

In this blog post, you’ll learn more about the SQL Server Error Code 21581 and the error message description that is shown SQL Server Error Code 21581 SQL Server Error Description for the Code :21581 Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of  2 or 3 (nonoverlapping partitions) for the @partition_options parameter…