sql server how retrieve info from transaction log?

microsoft.public.sqlserver.programming

11 Feb 2006 9:17 PM

mtczx232

where i can find simple (in .NET if have) how retrieve info from
transaction log?

12 Feb 2006 10:13 AM

Tibor Karaszi

There is none. The only TSQL command available are DBCC LOG command and the ::fn_dblog function.
These are not documented (you can Google for usage), but they basically return only binary
information. Use one of the log reader tools (I've listed some on my links page), if you are lucky,
they might have an API defined.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

<mtczx***@yahoo.com> wrote in message news:1139692675.482339.257700@g44g2000cwa.googlegroups.com...
> where i can find simple (in .NET if have) how retrieve info from
> transaction log?
>