Thanks for clarifying this transaction.I am trying to truncate it because
it is growing and consuming the space in the log drive and once the drive
is full no more transactions could be made against the database.
On Thu, Sep 8, 2016 at 3:42 PM Tim Bain [via ActiveMQ] <
ml-node+s2283324n4716304...@n
Thankx Tim,
Actually I can capture what is running against the database in different
time and every time it shows me this:
session_id
Login Name
Database
Begin Time
Log Records
Log Bytes Used
Log Bytes Rsvd
statement_text
Last T-SQL Text
65
db_user
dbname
51:05.5
33097
4104092
71428
Hi ,we have Blackboard application which use ActiveMQ, it is causing the
database to grew huge in size , we can't truncate because there is always
active transaction. transaction Logs never get cleared out after taking
backup due to an open transaction. , s there any way to force AMQ to commit
the
