Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  Count different between Linked server and Oracle

Author  Topic  sra98a Starting Member 1 Post Posted - 2013-09-18 : 10:33:52 If I log onto sqldeveloper and Query a oracle table I get a count of 34000. If I log onto SQLSERVER and to a select to the same oracle linked server, I get a different count. Any idea? SELECT * FROM OPENQUERY(ACU_PROD, 'SELECT * FROM ACU.ACTIVE_DIR_PEOPLE') received a 7000 count difference.