Category: SQL Server

SQL Server Error Code – 21017 cannot perform sql server 7.0 compatible

In this blog post, you’ll learn more about the SQL Server Error Code 21017 and the error message description that is shown SQL Server Error Code 21017 SQL Server Error Description for the Code :21017 Cannot perform SQL Server 7.0 compatible checksum operation on a merge article that has a vertical or horizontal partition. Rowcount validation and SQL Server 2000 compatible binary checksum operation can…

SQL Server Error Code – 21668 the constraint “%s” was not created beca

In this blog post, you’ll learn more about the SQL Server Error Code 21668 and the error message description that is shown SQL Server Error Code 21668 SQL Server Error Description for the Code :21668 The constraint “%s” was not created because one or more columns in the constraint is not published. Either include all columns in the published article, or alter the constraint to…

SQL Server Error Code – 41502 failed to deregister client (id %ls) fro

In this blog post, you’ll learn more about the SQL Server Error Code 41502 and the error message description that is shown SQL Server Error Code 41502 SQL Server Error Description for the Code :41502 Failed to deregister client (ID %ls) from asynchronous operations administrator.  The client has not registered with the administrator.  Check that the specified client ID is correct, then retry the operation.

SQL Server Error Code – 21792 the table ‘%s.%s’ already appears in the

In this blog post, you’ll learn more about the SQL Server Error Code 21792 and the error message description that is shown SQL Server Error Code 21792 SQL Server Error Description for the Code :21792 The table ‘%s.%s’ already appears in the transactional publication ‘%s’ on Publisher ‘%s’. The Oracle Gateway publishing option (the default) allows a table to be included as an article in…

Column Alias in SQL Query

When returning the query results , you want to provide an alternate name for the column for readability purpose , you can use the AS clause to specify the column alias in SQL Query. How to specify Column alias in SQL Query ? Below is an example of the usage of the column alias in SQL Query. Every column in the Query result has a…

SQL Server Error Code – 10704 to rethrow an error, a throw statement m

In this blog post, you’ll learn more about the SQL Server Error Code 10704 and the error message description that is shown SQL Server Error Code 10704 SQL Server Error Description for the Code :10704 To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.