Category: SQL Server

SQL Server Error Code – 2574 table error: page %s_pgid is empty in ob

In this blog post, you’ll learn more about the SQL Server Error Code 2574 and the error message description that is shown SQL Server Error Code 2574 SQL Server Error Description for the Code :2574 Table error: Page %S_PGID is empty in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). This is not permitted at level %d of…

SQL Server Error Code – 9538 paths with same path expression indexed

In this blog post, you’ll learn more about the SQL Server Error Code 9538 and the error message description that is shown SQL Server Error Code 9538 SQL Server Error Description for the Code :9538 Paths with same path expression indexed with selective XML index ‘%.*ls’ should have SINGLETON option either specified for all of them or for none of them.

SQL Server Error Code – 20689 the check for a publisher needing a new

In this blog post, you’ll learn more about the SQL Server Error Code 20689 and the error message description that is shown SQL Server Error Code 20689 SQL Server Error Description for the Code :20689 The check for a Publisher needing a new identity range allocation failed on table %s. This check occurs every time the Merge Agent and Snapshot Agent run. Rerun the Merge…

SQL Server Error Code – 26072 found multiple dependent virtual network

In this blog post, you’ll learn more about the SQL Server Error Code 26072 and the error message description that is shown SQL Server Error Code 26072 SQL Server Error Description for the Code :26072 Found multiple dependent virtual network names for the Windows Failover Cluster Resource ‘%ls’. SQL Server will only listen on the first virtual network name resource: ‘%ls’. This may indicate that…

SQL Server Error Code – 13601 property ‘%.*ls’ cannot be generated in

In this blog post, you’ll learn more about the SQL Server Error Code 13601 and the error message description that is shown SQL Server Error Code 13601 SQL Server Error Description for the Code :13601 Property ‘%.*ls’ cannot be generated in JSON output due to a conflict with another column name or alias. Use different names and aliases for each column in SELECT list.

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…