Tuesday, March 27, 2012

binnacles

Is there a way to view binnacles (or details of
transactions) in SQL Server 2000
Hi,
Did you meant reading the transaction log file;
There is an undocumented command (DBCC LOG) that lets you see the records in
transaction log.
Here is an sample:
DBCC LOG('DBNAME',2)
or there is good tool from Lumigent called Log explorer
www.lumigent.com
Thanks
Hari
MCDBA
"Juan" <anonymous@.discussions.microsoft.com> wrote in message
news:177e901c418ea$f19f4f60$a501280a@.phx.gbl...
> Is there a way to view binnacles (or details of
> transactions) in SQL Server 2000

No comments:

Post a Comment