How can we find the open transactions details in sql server

 

Yes, it is possible. 

select * from sysprocesses where open_tran > 0