You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Cannot process the object "%ls". The OLE DB provider "%ls" for linked server "%ls" indicates that either the object has no columns or the current user does not have permissions on that object.
Explanation
The error typically occurs when there's an issue with the query passed to the Open Query statement.
User action
Review the following potential causes and recommended solutions for this error.
OPENQUERY doesn't return a result set
Use four-part names (linked_server_name.catalog.schema.object_name) to perform insert, update, or delete operations.
Reference the OPENQUERY function as the target table of an INSERT, UPDATE, or DELETE statement, depending on the capabilities of the OLE DB provider, as documented in the Examples section of "OPENQUERY (Transact-SQL)."
The OLEDB provider for a pass-through query returns zero columns
Examine and correct the pass-through query text to ensure it returns valid columns from the remote data source.
Execute the pass-through query directly against the remote data source using the client tools provided for that data source and ensure at least one valid column is returned. For examples of pass-through queries, see OPENQUERY (Transact-SQL).
Use a four-part linked server query as an alternative linked_server_name.database.schema.object.
The first line in the query is a comment
Move the comment to the end of the query or procedure.