::FN_DBLOG() - Problem in retreiving [row data]

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.Both fn_dblog() and dbcc log are undocumented and therefore unsupported
features of SQL Server, so in all cases you are on you own.
If you can send me a repro I will look at this. What are you trying to do
with that information anyhow?
GertD@.SQLDev.Net
"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.
>sql

::FN_DBLOG - Retreiving [row data]

Subj: ::FN_DBLOG - Retreiving [row data]
Hello
While attempting to retrieve [row data] column using ::FN_DBLOG
an empty '0x' value is passed back.
The retrived record does contain row data. It can be seen when using DBCC LO
G.
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.Hi hillel,
I don't know exactly what you are looking for but launching this you can
recover the log info:
SELECT * FROM ::fn_dblog(null,null)
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"hillel" wrote:

> Subj: ::FN_DBLOG - Retreiving [row data]
> Hello
> While attempting to retrieve [row data] column using ::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.
>|||Thank you Enric.
My question is very specific.
In SQL 2000 - there are 2 interfaces by which I can access the transaction
LOG:
DBCC LOG is not a very convinient API in many aspects.
::FN_DBLOG() is much more tempting but - surprisingly - it does not display
the [row data] columns - as seen below:
SELECT [Current LSN],[Transaction ID],[Object Name],[row data]
FROM ::fn_dblog(null,null) where operation='LOP_INSERT_ROWS'
0000000b:0000018b:0002 0000:000005bf dbo
.jobs (1977058079) 0x
0000000b:00000190:0002 0000:000005c1 dbo
.jobs (1977058079) 0x
0000000b:00000190:0003 0000:000005c1 dbo
.jobs (1977058079) 0x
There is data associated with these records - as seen below:
dbcc log(DB5,3,logrecs,'LOP_INSERT_ROWS')
0000000b:0000018b:0002 ...0000:000005bf... dbo.jobs (1977058079)...
0x3000080025004749040000010030004261636B
75705F313931393139313931393139313931
3931393139313931393139
Did I miss something in the ::FN_DBLOG() invocation - or- what...?
Thanks
Hillel.
"Enric" wrote:
> Hi hillel,
> I don't know exactly what you are looking for but launching this you can
> recover the log info:
> SELECT * FROM ::fn_dblog(null,null)
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)
>
> "hillel" wrote:
>

.ldf log file

Hi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
still weigths the same...
Is there any procedure shrink this file??
thanks in advanceHi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
still weigths the same...
Is there any procedure shrink this file??
thanks in advance

go to the database in question, type in CHECKPOINT. Wait a little while, then run a shrinkdb. If you are not going to be doing log backups, you need to set the recovery mode to Simple so you don't keep having trouble with this though. After you set it to simple, you can run a shrinkdb and you'll be fine.|||thanks,!
that worked pretty good...
regards,

**linked server**

Hi
I'm working with MS sql server 2000 and I want to add a linked server. but
there is an empty "provider name" combo box, with following message at the
bottom "Provider Name is one of the providers installed on the server"
what programs should I install in order to get a complete names of
providers and be able to continue?
(I have no problem on my personal client(WinXP) in our LAN, but this is a
problem in our server.)
my second question:
Is it possible to have a remote server throught VPN by a linked server?
(now I have the remote SQL server through a new SQL server registration
but I want to have it in a linked server in order to easily join its table
with my local network tables and ...)
Any help would be greatly appreciated.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/1) Do you try to create a linked server to another SQL Server? Check SQL
Server under Server Type option
2) I think it is permission issue, I have never tried it. Have you tried to
create a linked server?
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tk5uxesen9ig5y@.system109.parskhazar.net...
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/|||Hi
Try adding the linked server through T-SQL using something like:
EXEC sp_addlinkedserver @.server='RemoteSQLServer', @.srvproduct='',
@.provider='SQLOLEDB',
@.datasrc='RemoteSvr\SQLInstance'
If you can register the remote server you should be ok to define it as a
linked server. Response over the VPN may be quite slow.
John
"M" wrote:
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>