Link to home
Create AccountLog in
Avatar of bibi92
bibi92Flag for France

asked on

detect lock X on transactional log

Hello,

The db is in recovery model simple, but I can see with the command dbcc log (dbname, type=3) that the log can't empty.
How can I detect which process block the transactional log?
Thanks
Regards
bibi
ASKER CERTIFIED SOLUTION
Avatar of Humpdy
Humpdy

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of bibi92

ASKER

Thanks bibi