The behavior of distributed queries against a remote table depends on the functionality of the OLE DB provider used to access the table. The OLE DB specification defines a set of objects for OLE DB providers. Each object has a set of interfaces. Many of these objects and interfaces are optional and may not be supported by a provider. If an OLE DB provider does not support some of these objects and interfaces, then any distributed query functionality that depends on these components will not work with any remote tables accessed through that provider.