Showing posts with label confirmed. Show all posts
Showing posts with label confirmed. Show all posts

Wednesday, March 28, 2012

I don't remember how it was...

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

I don't remember how it was...

Using this system function (::fn_log(null,null)) you can find out how many transactions have been confirmed in your .LDF. Although by means of another system function you can see further information, such as statitical.

Any help would be very appreciated.

Thanks

There isn't a function by that name. There's a similarly named undocumented and unsupported function (that I'm not going to discuss) for use during troubleshooting by Product Support and the product group.

What exactly are you trying to find out?