Category: SQL Server
SQL Server Error Code – 4077 the statement failed because the sql_var
In this blog post, you’ll learn more about the SQL Server Error Code 4077 and the error message description that is shown SQL Server Error Code 4077 SQL Server Error Description for the Code :4077 The statement failed because the sql_variant value uses collation %.*ls, which is not recognized by older client drivers. Try upgrading the client operating system or applying a service update to…
SQL Server Error Code – 13605 column expressions and data sources with
In this blog post, you’ll learn more about the SQL Server Error Code 13605 and the error message description that is shown SQL Server Error Code 13605 SQL Server Error Description for the Code :13605 Column expressions and data sources without names or aliases cannot be formatted as JSON text using FOR JSON clause. Add alias to the unnamed column or table.
SQL Server Error Code – 13742 table ‘%.*ls’ contains records where ‘ge
In this blog post, you’ll learn more about the SQL Server Error Code 13742 and the error message description that is shown SQL Server Error Code 13742 SQL Server Error Description for the Code :13742 Table ‘%.*ls’ contains records where ‘GENERATED ALWAYS AS %ls’ is not equal to %ls.
Get the date in YYYY-MM-DD format in SQL Server.
You can retreive the date in the YYYY-MM-DD format in SQL Server using the CONVERT method as shown in this code snippet. How to get the date in YYYY-MM-DD format in SQL Server ?
SQL Server Error Code – 16620 cannot update sync schema because the fo
In this blog post, you’ll learn more about the SQL Server Error Code 16620 and the error message description that is shown SQL Server Error Code 16620 SQL Server Error Description for the Code :16620 Cannot update sync schema because the format of sync schema is invalid.
SQL Server Error Code – 6261 the clr type referenced by column “%.*ls
In this blog post, you’ll learn more about the SQL Server Error Code 6261 and the error message description that is shown SQL Server Error Code 6261 SQL Server Error Description for the Code :6261 The CLR type referenced by column “%.*ls” of table variable “%.*ls” has been dropped during the execution of the batch. Run the batch again.
SQL Server Error Code – 18458 login failed. the number of simultaneous
In this blog post, you’ll learn more about the SQL Server Error Code 18458 and the error message description that is shown SQL Server Error Code 18458 SQL Server Error Description for the Code :18458 Login failed. The number of simultaneous users already equals the %d registered licenses for this server. To increase the maximum number of simultaneous users, obtain additional licenses and then register…
SQL Server Error Code – 40990 specifying an elastic pool and/or changi
In this blog post, you’ll learn more about the SQL Server Error Code 40990 and the error message description that is shown SQL Server Error Code 40990 SQL Server Error Description for the Code :40990 Specifying an elastic pool and/or changing the service level objective or edition is not supported for ‘%s’ edition.
SQL Server Error Code – 41001 failed to obtain local computer name (er
In this blog post, you’ll learn more about the SQL Server Error Code 41001 and the error message description that is shown SQL Server Error Code 41001 SQL Server Error Description for the Code :41001 Failed to obtain local computer name (Error code %d). The supplied buffer may be too small, or there is a system error. For information about this error code, see “System…
SQL Server Error Code – 22979 the unique index ‘%s’ on table ‘%s’ is u
In this blog post, you’ll learn more about the SQL Server Error Code 22979 and the error message description that is shown SQL Server Error Code 22979 SQL Server Error Description for the Code :22979 The unique index ‘%s’ on table ‘%s’ is used by Change Data Capture. The constraint using this index cannot be dropped or disabled.
SQL Server Error Code – 39117 %.*ls external language statement failed
In this blog post, you’ll learn more about the SQL Server Error Code 39117 and the error message description that is shown SQL Server Error Code 39117 SQL Server Error Description for the Code :39117 %.*ls EXTERNAL LANGUAGE statement failed because the parameter ‘%s’ is not a valid expression.
SQL Server Error Code – 41207 a locale id that is not supported was sp
In this blog post, you’ll learn more about the SQL Server Error Code 41207 and the error message description that is shown SQL Server Error Code 41207 SQL Server Error Description for the Code :41207 A locale ID that is not supported was specified for a column with ‘STATISTICAL_SEMANTICS’. Please verify that the locale ID is correct and that the corresponding language statistics has been…
SQL Server Error Code – 561 failed to access file ?%.*ls?
In this blog post, you’ll learn more about the SQL Server Error Code 561 and the error message description that is shown SQL Server Error Code 561 SQL Server Error Description for the Code :561 Failed to access file ?%.*ls?
SQL Server Error Code – 7673 warning: full-text change tracking is cu
In this blog post, you’ll learn more about the SQL Server Error Code 7673 and the error message description that is shown SQL Server Error Code 7673 SQL Server Error Description for the Code :7673 Warning: Full-text change tracking is currently disabled for table or indexed view ‘%.*ls’.
SQL Server Error Code – 8712 index ‘%.*ls’, specified in the use plan
In this blog post, you’ll learn more about the SQL Server Error Code 8712 and the error message description that is shown SQL Server Error Code 8712 SQL Server Error Description for the Code :8712 Index ‘%.*ls’, specified in the USE PLAN hint, does not exist. Specify an existing index, or create an index with the specified name.
SQL Server Error Code – 13291 guid
In this blog post, you’ll learn more about the SQL Server Error Code 13291 and the error message description that is shown SQL Server Error Code 13291 SQL Server Error Description for the Code :13291 guid
SQL Server Error Code – 14664 database mail logging level: normal – 1,
In this blog post, you’ll learn more about the SQL Server Error Code 14664 and the error message description that is shown SQL Server Error Code 14664 SQL Server Error Description for the Code :14664 Database Mail logging level: normal – 1, extended – 2 (default), verbose – 3
SQL Server Error Code – 45184 operation id ‘%ls’ was not found.
In this blog post, you’ll learn more about the SQL Server Error Code 45184 and the error message description that is shown SQL Server Error Code 45184 SQL Server Error Description for the Code :45184 Operation Id ‘%ls’ was not found.
SQL Server Error Code – 33324 failed to parse the redirect info string
In this blog post, you’ll learn more about the SQL Server Error Code 33324 and the error message description that is shown SQL Server Error Code 33324 SQL Server Error Description for the Code :33324 Failed to parse the redirect info string
SQL Server Error Code – 40811 operation ‘%.*ls’ for database ‘%.*ls’ c
In this blog post, you’ll learn more about the SQL Server Error Code 40811 and the error message description that is shown SQL Server Error Code 40811 SQL Server Error Description for the Code :40811 Operation ‘%.*ls’ for database ‘%.*ls’ cannot be cancelled as it has already completed.