uhlenheuerdotnet
programming, .NET, linux and others

Inspect an open transaction in SQLServer

by Gregor Uhlenheuer on September 24, 2011

In case you are currently processing a huge amount of data in a transaction in your MS SQLServer you are usually not able to look into the already processed data. Enter the following command in your Management Studio in order to enable a sort of live-inspection:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

I found this really helpful tip on inpad.de

This post is tagged with sql, programming and sqlserver