Tag: MS SQL Server Error Codes
SQL Server Error Code – 6840 neither xmldata nor xmlschema supports n
In this blog post, you’ll learn more about the SQL Server Error Code 6840 and the error message description that is shown SQL Server Error Code 6840 SQL Server Error Description for the Code :6840 Neither XMLDATA nor XMLSCHEMA supports namespace elements or attributes such as ‘%.*ls’. Run the SELECT FOR XML statement without it or remove the namespace prefix declaration.
SQL Server Error Code – 8515 microsoft distributed transaction coordi
In this blog post, you’ll learn more about the SQL Server Error Code 8515 and the error message description that is shown SQL Server Error Code 8515 SQL Server Error Description for the Code :8515 Microsoft Distributed Transaction Coordinator (MS DTC) global state is not valid.
SQL Server Error Code – 27029 invalid error tolerant index metadata ve
In this blog post, you’ll learn more about the SQL Server Error Code 27029 and the error message description that is shown SQL Server Error Code 27029 SQL Server Error Description for the Code :27029 Invalid Error Tolerant Index metadata version.
SQL Server Error Code – 28073 an out of memory condition has occurred
In this blog post, you’ll learn more about the SQL Server Error Code 28073 and the error message description that is shown SQL Server Error Code 28073 SQL Server Error Description for the Code :28073 An out of memory condition has occurred in the Service Broker message transmitter (operation %i). Message transmission will resume in %i seconds.
SQL Server Error Code – 1402 witness did not find an entry for databa
In this blog post, you’ll learn more about the SQL Server Error Code 1402 and the error message description that is shown SQL Server Error Code 1402 SQL Server Error Description for the Code :1402 Witness did not find an entry for database mirroring GUID {%.8x-%.4x-%.4x-%.2x%.2x-%.2x%.2x%.2x%.2x%.2x%.2x}. A configuration mismatch exists. Retry the command, or reset the witness from one of the database mirroring partners.
SQL Server Error Code – 4140 the readcommittedlock lock hint is not a
In this blog post, you’ll learn more about the SQL Server Error Code 4140 and the error message description that is shown SQL Server Error Code 4140 SQL Server Error Description for the Code :4140 The READCOMMITTEDLOCK lock hint is not allowed on the target table of an INSERT statement.
SQL Server Error Code – 7732 cannot specify partition number in alter
In this blog post, you’ll learn more about the SQL Server Error Code 7732 and the error message description that is shown SQL Server Error Code 7732 SQL Server Error Description for the Code :7732 Cannot specify partition number in Alter index statement along with keyword ALL to rebuild partitions of table ‘%.*ls’ when the table does not have any regular indexes.
SQL Server Error Code – 14699 data collector cannot be enabled when sq
In this blog post, you’ll learn more about the SQL Server Error Code 14699 and the error message description that is shown SQL Server Error Code 14699 SQL Server Error Description for the Code :14699 Data Collector cannot be enabled when SQL Server Agent is stopped. Start SQL Server Agent.
SQL Server Error Code – 19139 unable to add listener endpoints. check
In this blog post, you’ll learn more about the SQL Server Error Code 19139 and the error message description that is shown SQL Server Error Code 19139 SQL Server Error Description for the Code :19139 Unable to add listener endpoints. Check for memory-related errors.
SQL Server Error Code – 39101 ‘%.*ls’ failed because it is not support
In this blog post, you’ll learn more about the SQL Server Error Code 39101 and the error message description that is shown SQL Server Error Code 39101 SQL Server Error Description for the Code :39101 ‘%.*ls’ failed because it is not supported in the edition of this SQL Server instance.
SQL Server Error Code – 45429 the operation failed because it was issu
In this blog post, you’ll learn more about the SQL Server Error Code 45429 and the error message description that is shown SQL Server Error Code 45429 SQL Server Error Description for the Code :45429 The operation failed because it was issued on a custom maintenance window database. This is prohibited by default. Please try again with a switch to disable this check if the…
SQL Server Error Code – 46914 insert into external table is disabled.
In this blog post, you’ll learn more about the SQL Server Error Code 46914 and the error message description that is shown SQL Server Error Code 46914 SQL Server Error Description for the Code :46914 INSERT into external table is disabled. Turn on the configuration option ‘allow polybase export’ to enable.