Posts by Cassimiro • 11 points
1 post
-
1
votes2
answers177
viewsA: Run an SQL script in transaction without it blocking other scripts accessing the same table
There is no way to do this, unfortunately this hurts consistency rules of SQL Server (and any other sgbd). You can try to do a database redundancy, in case, a secondary one that will be updated…