Returns information about a transaction log.
loginfo (dbid | dbname, option]
loginfo (dbid | dbname, option, option1]
select (convert(datetime, convert(binary(8), loginfo(4, 'oldest_active_transaction_date')), 109))
select loginfo(dbid, 'database_has_active_transaction'), loginfo(dbid, 'oldest_active_transaction_pct'), loginfo(dbid, 'oldest_active_transaction_spid'), loginfo(dbid, 'can_free_using_dump_tran'), loginfo(dbid, 'is_stp_blocking_dump'), loginfo(dbid, 'stp_span_pct')
has_act_tran OAtran_spid Act_log_portion_pct dump_tran_free_pct is_stp_blocking stp_span_pct log_occupied_pct ------------ ------------ ------------------- ------------------ --------------- ------------ --------------- 1 14 17 7 0 25 32
select loginfo(dbid, ‘xactspanbyspid’, spid) spid log_span_pct ---------------------- 15 2
The user must have sa_role to execute loginfo.