Tag: MS SQL Server Error Codes
SQL Server Error Code – 5305 the rowdump and lockres columns are only
In this blog post, you’ll learn more about the SQL Server Error Code 5305 and the error message description that is shown SQL Server Error Code 5305 SQL Server Error Description for the Code :5305 The rowdump and lockres columns are only valid on tables and indexed views on which the NOEXPAND hint is specified.
SQL Server Error Code – 9985 there is not enough memory to generate a
In this blog post, you’ll learn more about the SQL Server Error Code 9985 and the error message description that is shown SQL Server Error Code 9985 SQL Server Error Description for the Code :9985 There is not enough memory to generate a search property list cache. Rerun your full-text indexing statement when more resources are available.
SQL Server Error Code – 3976 the transaction name has the odd length
In this blog post, you’ll learn more about the SQL Server Error Code 3976 and the error message description that is shown SQL Server Error Code 3976 SQL Server Error Description for the Code :3976 The transaction name has the odd length %d. The batch has been aborted.
SQL Server Error Code – 11403 alter table switch statement failed. ind
In this blog post, you’ll learn more about the SQL Server Error Code 11403 and the error message description that is shown SQL Server Error Code 11403 SQL Server Error Description for the Code :11403 ALTER TABLE SWITCH statement failed. Indexed view ‘%.*ls’ is not aligned with table ‘%.*ls’. The partitioning column ‘%.*ls’ from the indexed view calculates its value from one or more columns…
SQL Server Error Code – 35328 alter index rebuild statement failed bec
In this blog post, you’ll learn more about the SQL Server Error Code 35328 and the error message description that is shown SQL Server Error Code 35328 SQL Server Error Description for the Code :35328 ALTER INDEX REBUILD statement failed because the %S_MSG option is not allowed when rebuilding a columnstore index. Rebuild the columnstore index without specifying the %S_MSG option.
SQL Server Error Code – 6940 invalid component named ‘%s’ found in gl
In this blog post, you’ll learn more about the SQL Server Error Code 6940 and the error message description that is shown SQL Server Error Code 6940 SQL Server Error Description for the Code :6940 Invalid component named ‘%s’ found in global scope. Only elements, attributes, types and groups can be defined in global context
SQL Server Error Code – 8721 cannot execute query. table hint in the
In this blog post, you’ll learn more about the SQL Server Error Code 8721 and the error message description that is shown SQL Server Error Code 8721 SQL Server Error Description for the Code :8721 Cannot execute query. TABLE HINT in the OPTION clause leads to ambiguous reference for object ‘%.*ls’. Consider USE PLAN query hint instead.
SQL Server Error Code – 15187 the %s_msg cannot be dropped because it
In this blog post, you’ll learn more about the SQL Server Error Code 15187 and the error message description that is shown SQL Server Error Code 15187 SQL Server Error Description for the Code :15187 The %S_MSG cannot be dropped because it is used by one or more %S_MSG(s).
SQL Server Error Code – 4131 a compile-time literal value is specifie
In this blog post, you’ll learn more about the SQL Server Error Code 4131 and the error message description that is shown SQL Server Error Code 4131 SQL Server Error Description for the Code :4131 A compile-time literal value is specified more than once for the variable “%.*ls” in one or more OPTIMIZE FOR clauses.
SQL Server Error Code – 20815 distribution agent profile enabled for t
In this blog post, you’ll learn more about the SQL Server Error Code 20815 and the error message description that is shown SQL Server Error Code 20815 SQL Server Error Description for the Code :20815 Distribution agent profile enabled for the processing LOB data using OLEDB streaming.
SQL Server Error Code – 22118 cannot enable change tracking on table ‘
In this blog post, you’ll learn more about the SQL Server Error Code 22118 and the error message description that is shown SQL Server Error Code 22118 SQL Server Error Description for the Code :22118 Cannot enable change tracking on table ‘%.*ls’. Change tracking is not supported when the primary key contains encrypted columns.
SQL Server Error Code – 8638 the query processor could not produce a
In this blog post, you’ll learn more about the SQL Server Error Code 8638 and the error message description that is shown SQL Server Error Code 8638 SQL Server Error Description for the Code :8638 The query processor could not produce a query plan because CURSOR fetch queries cannot reference external tables. Ensure that the input request does not contain remote UPDATE or DELETE on…
SQL Server Error Code – 13796 temporal application time period without
In this blog post, you’ll learn more about the SQL Server Error Code 13796 and the error message description that is shown SQL Server Error Code 13796 SQL Server Error Description for the Code :13796 Temporal application time period without overlaps can be defined only on a primary key or a unique constraint.
SQL Server Error Code – 40656 quota for maximum number of concurrent r
In this blog post, you’ll learn more about the SQL Server Error Code 40656 and the error message description that is shown SQL Server Error Code 40656 SQL Server Error Description for the Code :40656 Quota for maximum number of concurrent restores has been exceeded.
SQL Server Error Code – 138 correlation clause in a subquery not per
In this blog post, you’ll learn more about the SQL Server Error Code 138 and the error message description that is shown SQL Server Error Code 138 SQL Server Error Description for the Code :138 Correlation clause in a subquery not permitted.
SQL Server Error Code – 2564 dbcc shrinkfile for %.*ls is aborted. me
In this blog post, you’ll learn more about the SQL Server Error Code 2564 and the error message description that is shown SQL Server Error Code 2564 SQL Server Error Description for the Code :2564 DBCC SHRINKFILE for %.*ls is aborted. MEMORY_OPTIMIZED_DATA containers are not supported.
SQL Server Error Code – 13172 get conversation group
In this blog post, you’ll learn more about the SQL Server Error Code 13172 and the error message description that is shown SQL Server Error Code 13172 SQL Server Error Description for the Code :13172 GET CONVERSATION GROUP
SQL Server Error Code – 21686 the operation “%s” is not valid. valid o
In this blog post, you’ll learn more about the SQL Server Error Code 21686 and the error message description that is shown SQL Server Error Code 21686 SQL Server Error Description for the Code :21686 The operation “%s” is not valid. Valid operations are “add”, “drop”, and “help”.
SQL Server Error Code – 42031 this functionality is not supported for
In this blog post, you’ll learn more about the SQL Server Error Code 42031 and the error message description that is shown SQL Server Error Code 42031 SQL Server Error Description for the Code :42031 This functionality is not supported for A/B test isolated instances.
SQL Server Error Code – 266 transaction count after execute indicate
In this blog post, you’ll learn more about the SQL Server Error Code 266 and the error message description that is shown SQL Server Error Code 266 SQL Server Error Description for the Code :266 Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.