The OLE DB provider "SQLNCLI11" of the linked server "(NULL)" indicates that the object has no columns, or that the current user does not have permission to access the object.

Original: The OLE DB provider "SQLNCLI11" of the linked server "(NULL)" indicates that the object has no columns, or that the current user does not have permission to access the object.

SELECT * from    OPENROWSET('SQLOLEDB','server=.; UID=SA;PWD=SDTY-CC','exec DBMobileBJ.dbo.Do_CallProcess_Jcmx_Report');GO---Changed to----------SELECT * from    OPENROWSET('SQLOLEDB',               'server=.; UID=SA;PWD=SDTY-CC',               'SET fmtonly OFF; SET NOCOUNT on; EXEC DBMobileBJ.dbo.Do_CallProcess_Jcmx_Report'              );GO----plus SET fmtonly OFF; SET NOCOUNT on; 

The OLE DB provider "SQLNCLI11" of the linked server "(NULL)" indicates that the object has no columns, or that the current user does not have permission to access the object.