Tag: MS SQL Server Error Codes

SQL Server Error Code – 20664 the publisher cannot be assigned a new r

In this blog post, you’ll learn more about the SQL Server Error Code 20664 and the error message description that is shown SQL Server Error Code 20664 SQL Server Error Description for the Code :20664 The Publisher cannot be assigned a new range of identity values, because the values for the identity column’s data type have all been used. Change the data type in the…

SQL Server Error Code – 21211 the database is attached from a subscrip

In this blog post, you’ll learn more about the SQL Server Error Code 21211 and the error message description that is shown SQL Server Error Code 21211 SQL Server Error Description for the Code :21211 The database is attached from a subscription copy file without using sp_attach_subscription. Drop the database and reattach it using sp_attach_subscription.

SQL Server Error Code – 21723 the value specified for the @pubid param

In this blog post, you’ll learn more about the SQL Server Error Code 21723 and the error message description that is shown SQL Server Error Code 21723 SQL Server Error Description for the Code :21723 The value specified for the @pubid parameter of procedure ‘%s’ is not valid or is NULL. Verify that the Merge Agent is running correctly. Reinitalize the subscription if the problem…

SQL Server Error Code – 41158 failed to join local availability replic

In this blog post, you’ll learn more about the SQL Server Error Code 41158 and the error message description that is shown SQL Server Error Code 41158 SQL Server Error Description for the Code :41158 Failed to join local availability replica to availability group ‘%.*ls’.  The operation encountered SQL Server error %d and has been rolled back.  Check the SQL Server error log for more…

SQL Server Error Code – 16200 the statement failed because ‘approx_cou

In this blog post, you’ll learn more about the SQL Server Error Code 16200 and the error message description that is shown SQL Server Error Code 16200 SQL Server Error Description for the Code :16200 The statement failed because ‘APPROX_COUNT_DISTINCT’ does not support DISTINCT parameters. Consider using ‘APPROX_COUNT_DISTINCT’ without DISTINCT, or COUNT or COUNT_BIG with DISTINCT.