BUG: Distributed Query Predicate not Remoted when IDBSchemaRowset not Supported

ID: Q235060

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55863 (SQLBUG_70) BUG #: 55630 (SQLBUG_70)

SYMPTOMS

A distributed query against a provider, which does not support the IDBSchemaRowset interface, may not ship predicates to the remote server for non-string datatypes. This may cause a performance degradation as data is returned to SQL Server and filtered locally, rather than at the remote datasource. Using the Microsoft OLE DB Provider for ODBC (MSDASQL) with ODBC 2.5 and earlier version drivers may expose this problem.

CAUSE

If the provider does not support the IDBSchemaRowset interface SQL Server sees all columns as collation-incompatible by default. This prevents remoting even for non-string datatypes such as integer, decimal, numeric, where collation does not apply.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug