title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
---|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_7357 |
MSSQLSERVER_7357 |
PiJoCoder |
jopilov |
jopilov, aartigoyle, v-sidong |
08/08/2023 |
sql |
supportability |
reference |
|
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. |
The error typically occurs when there's an issue with the query passed to the Open Query statement.
Review the following potential causes and recommended solutions for this error.
- 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 anINSERT
,UPDATE
, orDELETE
statement, depending on the capabilities of the OLE DB provider, as documented in the Examples section of "OPENQUERY (Transact-SQL)."
- 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
.
- Move the comment to the end of the query or procedure.