April 5, 2006 at 7:33 am
::FN_DBLOG - Problem in retreiving [row data]
Hello
While attempting to retrieve [row data] column using select * from ::FN_DBLOG ...
an empty '0x' value is passed back.
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.
April 7, 2006 at 12:41 am
I didn't know the function, but sp_help fn_dblog gave some info.
use
your_db
go
declare
@StartLSN nvarchar(50)
declare @EndLSN nvarchar(50)
-- find LSN in sqlserverlog, ...
select @StartLSN = '19:4501:37', @EndLSN = '19:4517:1'
select
* from ::FN_DBLOG(@StartLSN, @EndLSN)
Works fine overhere.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 8, 2006 at 11:35 pm
Thanx - these basics are known.
However - as I try to retrieve [row data]
select [row data] from ::FN_DBLOG(@StartLSN, @EndLSN)
I get empty columns although there is data held there.
This is my problem in this regard.
Does anybody has any idea?
/Hillel
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply