Category: SQL Server

SQL Server Error Code – 35350 the statement failed because a columnsto

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

How to drop a table if it exists in SQL Server 2014 ?

Assume that you want to write a SQL Query in SQL Server which checks if the table exists in database and want to drop it , you can use the OBJECT_ID function to determine the table existence by passing the table name and the ‘U’ as parameters. How to drop a table if it exists in SQL Server 2014 ?

SQL Server Error Code – 8926 table error: cross object linkage: paren

In this blog post, you’ll learn more about the SQL Server Error Code 8926 and the error message description that is shown SQL Server Error Code 8926 SQL Server Error Description for the Code :8926 Table error: Cross object linkage: Parent page %S_PGID, slot %d in object %d, index %d, partition %I64d, AU %I64d (%.*ls), and page %S_PGID->next in object %d, index %d, partition %I64d,…

SQL Server Error Code – 49939 unable to initialize user-specified cert

In this blog post, you’ll learn more about the SQL Server Error Code 49939 and the error message description that is shown SQL Server Error Code 49939 SQL Server Error Description for the Code :49939 Unable to initialize user-specified certificate configuration. The server is being shut down. Verify that the certificate is correctly configured. Error[%d]. State[%d].

SQL Server Error Code – 21535 the article ‘%s’ is already published in

In this blog post, you’ll learn more about the SQL Server Error Code 21535 and the error message description that is shown SQL Server Error Code 21535 SQL Server Error Description for the Code :21535 The article ‘%s’ is already published in another publication, and is set to use nonoverlapping partitions with multiple subscribers per partition (@partition_options = 2). This setting does not permit the…