Category: SQL Server
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 – 40581 logically filtered secondaries are only
In this blog post, you’ll learn more about the SQL Server Error Code 40581 and the error message description that is shown SQL Server Error Code 40581 SQL Server Error Description for the Code :40581 Logically filtered secondaries are only supported if the secondary is a forwarder.