Shared locks are used when a transaction wants to read a resource. Note: transactions can hold shared locks on the same resource (not exclusive). In this example, SQL Server will acquire a shared lock ...

Running a transaction session block that spans multiple steps/queries on SQL Server 2016 Express apparently can causes the server to abnormally closes either the transaction or the connection during ...