Using this system function (::fn_dblog(null,null)) you find out how many transactions are been confirmed in your .LDF. Although by means of another system function you can see further information, i mean statistical ones.
Any help would be very appreciated.
Hi,
how about this one here:
DBCC LOGINFO(db_id)
Select * from fn_dblog(null,null)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment