`Use 'yourDB'
GO

-- Check this first
select db_name(database_id) as DBNAME,open_transaction_count
  from sys.dm_exec_requests
 where session_id = 'yourSPID'

--Then run the Begin Tran statement below, and check the above select statement again.

begin tran
go

rollback --- close with no changes`