Category: SQL Server

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.

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…