MSSQLSERVER_7357
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 7357 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | RMT_ZERO_COL_OBJECT |
| Message Text | 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
OPENQUERYfunction as the target table of anINSERT,UPDATE, orDELETEstatement, 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.