I had an issue last night with a POS system that froze after login.
Its old software and no documentation so I thought I could trace the transaction in the database and see what was up.

MSSQL has SQL profiler but is not included in SQL 2005 Express, so I found this awesome utility that lets you see the queries made to the database.

Now turns out it didn’t keep that incomplete transaction in the database, but it helped me locate the issue elsewhere.

Will definitely be keeping this in my list of handy tools for the future though.

Express Profiler