Tag: MS SQL Server Error Codes

SQL Server Error Code – 35210 failed to modify options for availabilit

In this blog post, you’ll learn more about the SQL Server Error Code 35210 and the error message description that is shown SQL Server Error Code 35210 SQL Server Error Description for the Code :35210 Failed to modify options for availability replica ‘%.*ls’ in availability group ‘%.*ls’. The specified availability group does not contain an availability replica with specified name. Verify that availability group name…

SQL Server Error Code – 21830 you cannot specify schema_option 0x4 (sc

In this blog post, you’ll learn more about the SQL Server Error Code 21830 and the error message description that is shown SQL Server Error Code 21830 SQL Server Error Description for the Code :21830 You cannot specify schema_option 0x4 (script identity as identity rather than the base data type) for article ‘%s’. The value specified for the parameter @identityrangemanagementoption is NONE. To replicate identity…

SQL Server Error Code – 22840 the application lock request ‘%s’ needed

In this blog post, you’ll learn more about the SQL Server Error Code 22840 and the error message description that is shown SQL Server Error Code 22840 SQL Server Error Description for the Code :22840 The application lock request ‘%s’ needed to modify Change Data Capture metadata was not granted. The value returned from the request was %d: -1 = timeout; -2 = canceled; -3…

SQL Server Error Code – 8710 aggregate functions that are used with c

In this blog post, you’ll learn more about the SQL Server Error Code 8710 and the error message description that is shown SQL Server Error Code 8710 SQL Server Error Description for the Code :8710 Aggregate functions that are used with CUBE, ROLLUP, or GROUPING SET queries must provide for the merging of subaggregates. To fix this problem, remove the aggregate function or write the…

SQL Server Error Code – 15320 an error occurred while decrypting %s_ms

In this blog post, you’ll learn more about the SQL Server Error Code 15320 and the error message description that is shown SQL Server Error Code 15320 SQL Server Error Description for the Code :15320 An error occurred while decrypting %S_MSG ‘%.*ls’ that was encrypted by the old master key. The FORCE option can be used to ignore this error and continue the operation, but…

SQL Server Error Code – 5268 dbcc %.*ls is performing an exhaustive s

In this blog post, you’ll learn more about the SQL Server Error Code 5268 and the error message description that is shown SQL Server Error Code 5268 SQL Server Error Description for the Code :5268 DBCC %.*ls is performing an exhaustive search of %d indexes for possible inconsistencies.  This is an informational message only. No user action is required.