admin管理员组

文章数量:1296889

What happens when you query tables from different databases in the same query and the databases have different isolation levels. Let's say one is read committed and the other is snapshot isolation.

What happens when you query tables from different databases in the same query and the databases have different isolation levels. Let's say one is read committed and the other is snapshot isolation.

  • sql-server
Share Improve this question edited Feb 11 at 22:21 Dale K 27.4k15 gold badges58 silver badges83 bronze badges asked Feb 11 at 22:17 owneyjsowneyjs 652 silver badges9 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 4

Databases don't have isolation levels. That's a property of a session.

There's a database setting called READ COMMITTED SNAPSHOT ISOLATION (RCSI) which changes the behavior of the READ COMMITTED isolation level. When you query objects in multiple databases while your session is in READ COMMITTED isolation level, each table will be read according to the RCSI setting of its database.

本文标签： sql serverCross Database Query Isolation LevelsStack Overflow

版权声明：本文标题：sql server - Cross Database Query Isolation Levels - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741631679a2389401.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。