Dynamics AX – design and code

Show uncommited records

Ever wanted to be able to see records before committing them? I bet you have. It is not possible in Dynamics AX, but you can do it in SQL Server Management Studio. It is really easy as well.

Start Management Studio and connect to the SQL Server. Now navigate to Tools -> Options. From there, Query Execution -> SQL Server -> Advanced. There is a setting called SET TRANSACTION ISOLATION LEVEL. Set it to READ UNCOMMITED. Click OK button and you are done.

Just remember that unless you always want to see uncommited data, it is good to reset this setting once done.