Find uncommitted transaction

The T-SQL script to find uncommitted transaction

SELECT SP.SPID,[TEXT] as SQLcode FROM SYS.SYSPROCESSES SP

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.[SQL_HANDLE])AS DEST WHERE OPEN_TRAN=1