Re: How to view Transaction Log

From: Ron Talmage (rtalmage@prospice.com)
Date: 09/06/02 

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Thu, 5 Sep 2002 21:56:33 -0700

Sudinda,

In addition to what BP and Satya said, you can also use the fn_dblog()
function which returns a bit more than the DBCC but less than Log Explorer.

select * from ::fn_dblog(null, null)

But to really understand what the individual operations are, Log Explorer is
the only tool available right now.

Ron 

--
Ron Talmage
SQL Server MVP
"sudindra" <sudindra@rediffmail.com> wrote in message
news:5f9501c253fb$ef1e43f0$9be62ecf@tkmsftngxa03...
> Dear All,
>
> How do I view the transaction log of a particular
> database in the SQL Server?
>
> What are the steps involved?
>
> Thanks in advance,
> Sudindra