Category: SQL Server
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.
SQL Server Error Code – 45125 parameter “%ls” cannot be empty or null.
In this blog post, you’ll learn more about the SQL Server Error Code 45125 and the error message description that is shown SQL Server Error Code 45125 SQL Server Error Description for the Code :45125 Parameter “%ls” cannot be empty or null.
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 – 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 – 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 – 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 – 3046 inconsistent metadata has been encounter
In this blog post, you’ll learn more about the SQL Server Error Code 3046 and the error message description that is shown SQL Server Error Code 3046 SQL Server Error Description for the Code :3046 Inconsistent metadata has been encountered. The only possible backup operation is a tail-log backup using the WITH CONTINUE_AFTER_ERROR or NO_TRUNCATE option.
SQL Server Error Code – 4945 alter table switch statement failed beca
In this blog post, you’ll learn more about the SQL Server Error Code 4945 and the error message description that is shown SQL Server Error Code 4945 SQL Server Error Description for the Code :4945 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*ls’.