Error 2762 The 'xxx' command is not allowed within a multi-statement transaction in the database

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database

While deploying the code from development team or support team or vendor provided code, you would have encountered below error and would have thought why this message and why to perform DDL statement inside a user transaction: The ‘%s’ command is not allowed within a multi-statement transaction in the ‘%.*s’ database. Lets understand why this …

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database Read More »