Run SQL statements in SSMS when there is a lock from integration tests

To be able to run the sql statement, set the transaction level to read uncommitted:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

 -- Run whatever sql you need to run: select * from XYZ

When you are done, put put it back:

SET TRANSACTION ISOLATION LEVEL READ COMMITTED