Tag: MS SQL Server Error Codes
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.
SQL Server Error Code – 6211 %s assembly failed because type ‘%.*ls’
In this blog post, you’ll learn more about the SQL Server Error Code 6211 and the error message description that is shown SQL Server Error Code 6211 SQL Server Error Description for the Code :6211 %s ASSEMBLY failed because type ‘%.*ls’ in %.*ls assembly ‘%.*ls’ has a static field ‘%.*ls’. Attributes of static fields in %.*ls assemblies must be marked readonly in Visual C#, ReadOnly…
SQL Server Error Code – 6323 the xml schema collection for variable ‘
In this blog post, you’ll learn more about the SQL Server Error Code 6323 and the error message description that is shown SQL Server Error Code 6323 SQL Server Error Description for the Code :6323 The xml schema collection for variable ‘%.*ls’ has been altered while the batch was being executed. Remove all XML schema collection DDL operations it is dependent on from the batch,…
SQL Server Error Code – 10786 the alter availability group command fai
In this blog post, you’ll learn more about the SQL Server Error Code 10786 and the error message description that is shown SQL Server Error Code 10786 SQL Server Error Description for the Code :10786 The ALTER AVAILABILITY GROUP command failed because it contained multiple MODIFY REPLICA options: %ls. Enter a separate ALTER AVAILABILITY GROUP … MODIFY REPLICA command for each replica option that you…
SQL Server Error Code – 13761 the hint ‘%.*ls’ is not supported with h
In this blog post, you’ll learn more about the SQL Server Error Code 13761 and the error message description that is shown SQL Server Error Code 13761 SQL Server Error Description for the Code :13761 The hint ‘%.*ls’ is not supported with history table for memory optimized temporal table while SYSTEM_VERSIONING is ON.
SQL Server Error Code – 33529 the audit filter predicate exceeds the m
In this blog post, you’ll learn more about the SQL Server Error Code 33529 and the error message description that is shown SQL Server Error Code 33529 SQL Server Error Description for the Code :33529 The audit filter predicate exceeds the maximum allowed length of %d characters.
SQL Server Error Code – 9727 dialog security is not available for thi
In this blog post, you’ll learn more about the SQL Server Error Code 9727 and the error message description that is shown SQL Server Error Code 9727 SQL Server Error Description for the Code :9727 Dialog security is not available for this conversation because there is no remote service binding for the target service. Create a remote service binding, or specify ENCRYPTION = OFF in…
SQL Server Error Code – 10113 cannot create %s_msg on view “%.*ls” bec
In this blog post, you’ll learn more about the SQL Server Error Code 10113 and the error message description that is shown SQL Server Error Code 10113 SQL Server Error Description for the Code :10113 Cannot create %S_MSG on view “%.*ls” because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join…
SQL Server Error Code – 21079 the rpc security information for the pub
In this blog post, you’ll learn more about the SQL Server Error Code 21079 and the error message description that is shown SQL Server Error Code 21079 SQL Server Error Description for the Code :21079 The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it.
SQL Server Error Code – 4159 delayed clr type instances require local
In this blog post, you’ll learn more about the SQL Server Error Code 4159 and the error message description that is shown SQL Server Error Code 4159 SQL Server Error Description for the Code :4159 Delayed CLR type instances require local base table column as an argument.
SQL Server Error Code – 13387 provider error – no explanation is avail
In this blog post, you’ll learn more about the SQL Server Error Code 13387 and the error message description that is shown SQL Server Error Code 13387 SQL Server Error Description for the Code :13387 Provider Error – No explanation is available, consult EKM Provider for details
SQL Server Error Code – 19124 unable to retrieve registry settings for
In this blog post, you’ll learn more about the SQL Server Error Code 19124 and the error message description that is shown SQL Server Error Code 19124 SQL Server Error Description for the Code :19124 Unable to retrieve registry settings for a specific IP address.
SQL Server Error Code – 47118 the ‘%ls’ option must be specified with
In this blog post, you’ll learn more about the SQL Server Error Code 47118 and the error message description that is shown SQL Server Error Code 47118 SQL Server Error Description for the Code :47118 The ‘%ls’ option must be specified with a valid value when updating the external lease status on availability group ‘%.*ls’.