Hi,

I am using ::fn_fblog() function to read my on line transaction log.

I am excuting the below query
select * from ::fn_dblog(null,null).

But in [Row Data] I am just getting 0x value and neither I am getting any value for [Old Value] and [New Value] column.
I am reading this online log for some update operation on my table.

Can some help me how to get these values through ::fn_dblog().

I don't want use dbcc log command to because in that I can not directly fire the SQL select query and specify some filter.

Any help is appreciated.

Thanks in advance

Pushkar

Have you considered using a 3rd party tool for this?
Reading the log yourself is definitely not a trivial undertaking...
http://www.aspfaq.com/2449




I am using ::fn_fblog() function to read my on line transaction log.

I am excuting the below query
select * from ::fn_dblog(null,null).

But in [Row Data] I am just getting 0x value and neither I am getting any
value for [Old Value] and [New Value] column.
I am reading this online log for some update operation on my table.

Can some help me how to get these values through ::fn_dblog().

I don't want use dbcc log command to because in that I can not directly fire
the SQL select query and specify some filter.

Any help is appreciated.

Thanks in advance

Pushkar

Is there a better way to do this very simple query(s)?
SQL HELP
INSTEAD OF INSERT TRIGGER AND NULL
Trigger Help
readinf blob data in sql trigger