"Hillel" <hillel.eilat@gmail.com> wrote in message
news:1144768876.281792.244330@e56g2000cwe.googlegroups.com...
> Subj: ::FN_DBLOG() - Problem in retreiving [row data]
>
> Hello
>
> While attempting to retrieve [row data] column using ::FN_DBLOG
> an empty '0x' value is passed back:
>
> select [Current Lsn], [row data] from ::fn_dblog(null,null)
>
> The retrived record does contain row data. It can be seen when using
> DBCC LOG.
> However - DBCC LOG is not as versatile as ::FN_DBLOG(): which supports
> a standard SQL query. In addition - DBCC seems to be a more resource
> consuming
> piece.
>
> Please do not propse a 3rd party software solution.
> I need the [row data] 'as is' in its very basic binary raw format and
> ::FN_DBLOG() fits exactly to my needs.
>
> Any help will be appreciated.
>
> Regards
>
> Hillel.
>