Hi -
I am using DBCC log('db_name',4)
but it's only showing todays or active transactions
say i have executed 2000 transaction
before executed Query:
 Total number of records =2076
After executed 2000 transaction(Query):
 Total number of records =705

Also I used :fn_dblog with the same results.
select * FROM ::fn_dblog(null,null)

Is there a way to read previous/inactive transactions?
Is there a function or method to accomplish that?

I am using SQL Server 2000 & 2005 with full recovery model.
Any help would be appreciated.

Thanks,
Baddy

---

Thanks,
Baddy