111212;不能在事务内执行操作 [英] 111212;Operation cannot be performed within a transaction

问题描述

最近，我开始使用Azure，并试图启动SQL DW数据库并在其中运行一些查询以供使用案例.

 Recently I have started using Azure and was trying to spin up a SQL DW database and run some query there for some use cases.

                但是在尝试运行简单的create table语句时连接到数据库后，它抛出以下错误:

111212；无法在交易中执行操作.

                感谢您的帮助.

                

推荐答案

SQL Data Warehouse支持将事务作为数据仓库工作负载的一部分.但是，为确保按比例维护SQL Data Warehouse的性能，某些功能 与SQL Server相比受到限制. 

SQL Data Warehouse supports transactions as part of the data warehouse workload. However, to ensure the performance of SQL Data Warehouse is maintained at scale some features are limited when compared to SQL Server. 

有关详细信息，请参阅"

For more details, refer "Using transactions in SQL Data Warehouse".

要了解有关优化交易的更多信息，请参见 SQL数据仓库最佳做法.

To learn more about optimizing transactions, see Transactions best practices. To learn about other SQL Data Warehouse best practices, see SQL Data Warehouse best practices.

这篇关于111212;不能在事务内执行操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！