Category: SQL Server
SQL Server Error Code – 46515 the specified sharding column name does
In this blog post, you’ll learn more about the SQL Server Error Code 46515 and the error message description that is shown SQL Server Error Code 46515 SQL Server Error Description for the Code :46515 The specified sharding column name does not match any column in the external table definition.
SQL Server Error Code – 144 cannot use an aggregate or a subquery in
In this blog post, you’ll learn more about the SQL Server Error Code 144 and the error message description that is shown SQL Server Error Code 144 SQL Server Error Description for the Code :144 Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
SQL Server Error Code – 4847 bulk copying into a table with bigint co
In this blog post, you’ll learn more about the SQL Server Error Code 4847 and the error message description that is shown SQL Server Error Code 4847 SQL Server Error Description for the Code :4847 Bulk copying into a table with bigint columns is not supported for versions earlier than SQL Server 2000.
SQL Server Error Code – 9464 xml parsing: line %d, character %d, xml
In this blog post, you’ll learn more about the SQL Server Error Code 9464 and the error message description that is shown SQL Server Error Code 9464 SQL Server Error Description for the Code :9464 XML parsing: line %d, character %d, XML namespace prefix ‘xml’ can only be associated with the URI http://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes.
SQL Server Error Code – 10601 cannot specify included columns for a cl
In this blog post, you’ll learn more about the SQL Server Error Code 10601 and the error message description that is shown SQL Server Error Code 10601 SQL Server Error Description for the Code :10601 Cannot specify included columns for a clustered index.
SQL Server Error Code – 12417 only one query store option can be given
In this blog post, you’ll learn more about the SQL Server Error Code 12417 and the error message description that is shown SQL Server Error Code 12417 SQL Server Error Description for the Code :12417 Only one Query Store option can be given in ALTER DATABASE statement.
SQL Server Error Code – 13305 query_store
In this blog post, you’ll learn more about the SQL Server Error Code 13305 and the error message description that is shown SQL Server Error Code 13305 SQL Server Error Description for the Code :13305 QUERY_STORE
SQL Server Error Code – 39128 external language runtime for ‘%s’ could
In this blog post, you’ll learn more about the SQL Server Error Code 39128 and the error message description that is shown SQL Server Error Code 39128 SQL Server Error Description for the Code :39128 External language runtime for ‘%s’ could not be provisioned. Error code 0x%08x.
How to disable Foreign Key constraints using T-SQL in SQL Server ?
You can enable or disable the foreign key constraints for a table in a SQL Server using the ALTER statement. How to disable Foreign Key constraints using T-SQL in SQL Server ? Here’s the T-SQL query to disable all the constraints of the table “Employee”. If you want to enable all the constraints of the table , here’s how you do it.
SQL Server Error Code – 3964 transaction failed because this ddl stat
In this blog post, you’ll learn more about the SQL Server Error Code 3964 and the error message description that is shown SQL Server Error Code 3964 SQL Server Error Description for the Code :3964 Transaction failed because this DDL statement is not allowed inside a snapshot isolation transaction. Since metadata is not versioned, a metadata change can lead to inconsistency if mixed within snapshot…
SQL Server Error Code – 8412 the syntax of the service name ‘%.*ls’ i
In this blog post, you’ll learn more about the SQL Server Error Code 8412 and the error message description that is shown SQL Server Error Code 8412 SQL Server Error Description for the Code :8412 The syntax of the service name ‘%.*ls’ is invalid.
SQL Server Error Code – 15542 cannot create a key without specifying a
In this blog post, you’ll learn more about the SQL Server Error Code 15542 and the error message description that is shown SQL Server Error Code 15542 SQL Server Error Description for the Code :15542 Cannot create a key without specifying an encryptor.
SQL Server Error Code – 15705 automatic tuning option %.*ls cannot be
In this blog post, you’ll learn more about the SQL Server Error Code 15705 and the error message description that is shown SQL Server Error Code 15705 SQL Server Error Description for the Code :15705 Automatic Tuning option %.*ls cannot be enabled, because Query Store is not turned on.
SQL Server Error Code – 13509 cannot create generated always column wh
In this blog post, you’ll learn more about the SQL Server Error Code 13509 and the error message description that is shown SQL Server Error Code 13509 SQL Server Error Description for the Code :13509 Cannot create generated always column when SYSTEM_TIME period is not defined.
SQL Server Error Code – 13949 the table name or alias ‘%.*s’ was marke
In this blog post, you’ll learn more about the SQL Server Error Code 13949 and the error message description that is shown SQL Server Error Code 13949 SQL Server Error Description for the Code :13949 The table name or alias ‘%.*s’ was marked as FOR PATH but was not used in the recursive section of a SHORTEST_PATH clause.
SQL Server Error Code – 14539 only a standard or enterprise edition of
In this blog post, you’ll learn more about the SQL Server Error Code 14539 and the error message description that is shown SQL Server Error Code 14539 SQL Server Error Description for the Code :14539 Only a Standard or Enterprise edition of SQL Server can be enlisted into an MSX.
SQL Server Error Code – 19245 empty output token is returned by sspi d
In this blog post, you’ll learn more about the SQL Server Error Code 19245 and the error message description that is shown SQL Server Error Code 19245 SQL Server Error Description for the Code :19245 Empty output token is returned by SSPI during security context negotiation. Check for network packet corruption or other networking issues.
SQL Server Error Code – 25723 an error occurred while obtaining metada
In this blog post, you’ll learn more about the SQL Server Error Code 25723 and the error message description that is shown SQL Server Error Code 25723 SQL Server Error Description for the Code :25723 An error occurred while obtaining metadata information from the file “%s”. The file may be damaged.
SQL Server Error Code – 40984 restore and georestore target cannot be
In this blog post, you’ll learn more about the SQL Server Error Code 40984 and the error message description that is shown SQL Server Error Code 40984 SQL Server Error Description for the Code :40984 Restore and GeoRestore target cannot be free database.
SQL Server Error Code – 18774 the stored procedure %s must be executed
In this blog post, you’ll learn more about the SQL Server Error Code 18774 and the error message description that is shown SQL Server Error Code 18774 SQL Server Error Description for the Code :18774 The stored procedure %s must be executed within a transaction.