Category: SQL Server
SQL Server Error Code – 27014 deletion failed because token does not o
In this blog post, you’ll learn more about the SQL Server Error Code 27014 and the error message description that is shown SQL Server Error Code 27014 SQL Server Error Description for the Code :27014 Deletion failed because token does not occur in index. Error Tolerant Index is corrupt.
SQL Server Error Code – 33508 column ‘%.*ls’ cannot be passed as a par
In this blog post, you’ll learn more about the SQL Server Error Code 33508 and the error message description that is shown SQL Server Error Code 33508 SQL Server Error Description for the Code :33508 Column ‘%.*ls’ cannot be passed as a parameter for a BLOCK security predicate because the column definition contains an expression using a window function. Modify the BLOCK security predicates for…
SQL Server Error Code – 3272 the ?%ls? device has a hardware sector s
In this blog post, you’ll learn more about the SQL Server Error Code 3272 and the error message description that is shown SQL Server Error Code 3272 SQL Server Error Description for the Code :3272 The ?%ls? device has a hardware sector size of %d, but the block size parameter specifies an incompatible override value of %d. Reissue the statement using a compatible block size.
SQL Server Error Code – 20525 table ‘%s’ might be out of synchronizati
In this blog post, you’ll learn more about the SQL Server Error Code 20525 and the error message description that is shown SQL Server Error Code 20525 SQL Server Error Description for the Code :20525 Table ‘%s’ might be out of synchronization. Rowcounts (actual: %s, expected %s). Checksum values (actual: %s, expected: %s).
SQL Server Error Code – 21776 failed to generate published column bitm
In this blog post, you’ll learn more about the SQL Server Error Code 21776 and the error message description that is shown SQL Server Error Code 21776 SQL Server Error Description for the Code :21776 Failed to generate published column bitmap for article ‘%s’.
SQL Server Error Code – 22510 retrieving publication information.
In this blog post, you’ll learn more about the SQL Server Error Code 22510 and the error message description that is shown SQL Server Error Code 22510 SQL Server Error Description for the Code :22510 Retrieving publication information.
SQL Server Error Code – 4102 the readpast lock hint is only allowed o
In this blog post, you’ll learn more about the SQL Server Error Code 4102 and the error message description that is shown SQL Server Error Code 4102 SQL Server Error Description for the Code :4102 The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause.
SQL Server Error Code – 35266 always on availability groups connection
In this blog post, you’ll learn more about the SQL Server Error Code 35266 and the error message description that is shown SQL Server Error Code 35266 SQL Server Error Description for the Code :35266 Always On Availability Groups connection with %S_MSG database established for %S_MSG database ‘%.*ls’ on the availability replica ‘%.*ls’ with Replica ID: {%.8x-%.4x-%.4x-%.2x%.2x-%.2x%.2x%.2x%.2x%.2x%.2x}. This is an informational message only. No user…
SQL Server Error Code – 5855 the affinity setting was not changed. th
In this blog post, you’ll learn more about the SQL Server Error Code 5855 and the error message description that is shown SQL Server Error Code 5855 SQL Server Error Description for the Code :5855 The affinity setting was not changed. This can be caused by low system resources.
SQL Server Error Code – 7117 error reading large object (lob) data fr
In this blog post, you’ll learn more about the SQL Server Error Code 7117 and the error message description that is shown SQL Server Error Code 7117 SQL Server Error Description for the Code :7117 Error reading large object (LOB) data from the tabular data stream (TDS).
SQL Server Error Code – 20611 cannot add the article. publications tha
In this blog post, you’ll learn more about the SQL Server Error Code 20611 and the error message description that is shown SQL Server Error Code 20611 SQL Server Error Description for the Code :20611 Cannot add the article. Publications that allow transformable subscriptions with Data Transformation Services (DTS) can only include tables and indexed views that are published as tables.
SQL Server Error Code – 41636 fabric service ‘%ls’ (partition id ‘%ls’
In this blog post, you’ll learn more about the SQL Server Error Code 41636 and the error message description that is shown SQL Server Error Code 41636 SQL Server Error Description for the Code :41636 Fabric Service ‘%ls’ (partition ID ‘%ls’) is unable to enqueue a work item for the database restart of ‘%ls’ database (ID %d). The administrator may have exhausted all available resources. …
SQL Server Error Code – 49910 software usage metrics is disabled.
In this blog post, you’ll learn more about the SQL Server Error Code 49910 and the error message description that is shown SQL Server Error Code 49910 SQL Server Error Description for the Code :49910 Software Usage Metrics is disabled.
SQL Server Error Code – 4446 cannot update the union all view “%.*ls”
In this blog post, you’ll learn more about the SQL Server Error Code 4446 and the error message description that is shown SQL Server Error Code 4446 SQL Server Error Description for the Code :4446 Cannot update the UNION ALL view “%.*ls” because the definition of column “%.*ls” of view “%.*ls” is used by another view column.
SQL Server Error Code – 6507 failed to open malformed assembly ‘%ls’
In this blog post, you’ll learn more about the SQL Server Error Code 6507 and the error message description that is shown SQL Server Error Code 6507 SQL Server Error Description for the Code :6507 Failed to open malformed assembly ‘%ls’ with HRESULT 0x%x.
SQL Server Error Code – 15647 no views with schema binding reference t
In this blog post, you’ll learn more about the SQL Server Error Code 15647 and the error message description that is shown SQL Server Error Code 15647 SQL Server Error Description for the Code :15647 No views with schema binding reference table ‘%ls’.
SQL Server Error Code – 20675 the identity range values cannot be null
In this blog post, you’ll learn more about the SQL Server Error Code 20675 and the error message description that is shown SQL Server Error Code 20675 SQL Server Error Description for the Code :20675 The identity range values cannot be NULL.
SQL Server Error Code – 21661 the value specified for the @shutdown_ag
In this blog post, you’ll learn more about the SQL Server Error Code 21661 and the error message description that is shown SQL Server Error Code 21661 SQL Server Error Description for the Code :21661 The value specified for the @shutdown_agent parameter for article ‘%s’ must be 0 or 1.
How to get the Size of all tables in a SQL Server ?
In SQL Server 2014 Management Studio , you can get the size of all tables in a SQL Server from the Object explorer details window. How to get the Size of all tables in a SQL Server ? 1. In SQL Management Studio 2014 , navigate to the Object explorer details screen from View -> Object explorer details menu or by simply pressing the F7…
SQL Server Error Code – 3726 could not drop object ?%.*ls? because it
In this blog post, you’ll learn more about the SQL Server Error Code 3726 and the error message description that is shown SQL Server Error Code 3726 SQL Server Error Description for the Code :3726 Could not drop object ?%.*ls? because it is referenced by a FOREIGN KEY constraint.