Please provide your code. Usually, you need to use the
four part (linked server name.database_name.owner_name.table_name)
notation when dealing with tables on a linked server.
The following is from BOL,
Identifying a Data Source Using a Linked Server Name
After a linked server is defined, a four-part name in the form
linked_server_name.catalog.schema.object_name can be used in Transact-SQL
statements to reference data objects in that linked server. The table
describes the parts of a four-part name.
Part name Description
linked_server_name Linked server referencing the OLE DB data source
catalog Catalog in the OLE DB data source that contains the object
schema Schema in the catalog that contains the object
object_name Data object in the schema
Microsoft? SQL ServerT uses the linked server name to identify the OLE DB
provider and the data source. The catalog, schema, and object_name
parameters are passed to the OLE DB provider to identify a specific data
object. When the linked server refers to an instance of SQL Server, catalog
refers to a database and schema refers to an owner ID.
This illustration shows how a four-part SQL Server name resolves to an
object in the OLE DB provider.
> SQL Server 7
> MQ SQL 3.2
> I am trying to update a table on a MQ SQL lined server, the trouble is the
> MQ SQL driver does not seem to support the owner part, any suggestions? Or
> link to some examples would be good.
> Thanks for any help in advance