is this a Bug in SQL Server 2000 ?

Here are 2 Linked server creation scripts
EXEC sp_addlinkedserver
@.server='baanb',
@.srvproduct='Oracle in OraHome92',
@.provider='MSDASQL',
@.datasrc='baan'
go
exec sp_addlinkedsrvlogin 'baanb',false,null,'pass','pass'
go
EXEC sp_addlinkedserver
@.server='baan',
@.srvproduct='Oracle in OraHome92',
@.provider=MSDAORA,
@.datasrc='baan'
go
exec sp_addlinkedsrvlogin 'baan',false,null,'pass','pass'
go
When i run these Queries
select count(*) from openquery(baanb,'select t$dsca from baan.ttiitm001400')
select count(*) from openquery(baan,'select t$dsca from baan.ttiitm001400')
I got (33732) rows from baanb
and (33831) rows from baan.
They r the same Oracle Server/same database/ same Tables but different Row
Counts Always with 99 rows difference.
But When i add this linked servers In SQL server 7.0 and run the same
queries. I got the same row count.
Any Explanations ?
Is It a bug ?> Here are 2 Linked server creation scripts
> EXEC sp_addlinkedserver
> @.server='baanb',
> @.srvproduct='Oracle in OraHome92',
> @.provider='MSDASQL',
> @.datasrc='baan'
> go
> exec sp_addlinkedsrvlogin 'baanb',false,null,'pass','pass'
> go
> EXEC sp_addlinkedserver
> @.server='baan',
> @.srvproduct='Oracle in OraHome92',
> @.provider=MSDAORA,
> @.datasrc='baan'
>
> go
> exec sp_addlinkedsrvlogin 'baan',false,null,'pass','pass'
> go
>
> When i run these Queries
> select count(*) from openquery(baanb,'select t$dsca from
baan.ttiitm001400')
> select count(*) from openquery(baan,'select t$dsca from
baan.ttiitm001400')
> I got (33732) rows from baanb
> and (33831) rows from baan.
> They r the same Oracle Server/same database/ same Tables but different Row
> Counts Always with 99 rows difference.
> But When i add this linked servers In SQL server 7.0 and run the same
> queries. I got the same row count.
>
> Any Explanations ?
> Is It a bug ?
>
--
It could be a bug with a client driver. On the first one you're using an
Oracle ODBC driver in conjunction with the Microsoft OLE DB Provider for
ODBC. On the second one, you're using the Microsoft OLE DB Provider for
Oracle.
Which linked server returned the correct result? Have you tried using a
third-party OLE DB provider for Oracle and compare the results?
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Is there any way to read the transaction log?

Hi there,

I need to recover certain transactions that I made on the server.

Those transactions were in scripts and I lost the files.

Is there a way to read the transaction log so that I can see what transactions were executed?

TIA

I would have a look at the product LogExplorer as it should do what you need.

|||The transaction log is a binary structure and is not designed to give this sort of information. As Glen points out, there are third-party companies who have licensed the file layouts from us and are able to reproduce the original statements from the logs. Lumigent's Log Explorer is one of these.

Is there any way to read the transaction log?

Hi there,

I need to recover certain transactions that I made on the server.

Those transactions were in scripts and I lost the files.

Is there a way to read the transaction log so that I can see what transactions were executed?

TIA

I would have a look at the product LogExplorer as it should do what you need.

|||The transaction log is a binary structure and is not designed to give this sort of information. As Glen points out, there are third-party companies who have licensed the file layouts from us and are able to reproduce the original statements from the logs. Lumigent's Log Explorer is one of these.