MaryJaneDoane
Programmer
I have a stored procedure that runs based on an open query. I am getting an error I can't resolve. Below is the code calling hte stored procedure. The stored procedure runs fine by it self. Any ideas.
select * from openquery(ccbdata01, 'SET FMTONLY OFF exec OREO.dbo.usp_GenerateTmpPivot')
Here is the error (Cannot process the object "SET FMTONLY OFF exec OREO.dbo.usp_GenerateTmpPivot". The OLE DB provider "SQLNCLI" for linked server "ccbdata01" indicates that either the object has no columns or the current user does not have permissions on that object.
)
Thank you
MaryJDoane
select * from openquery(ccbdata01, 'SET FMTONLY OFF exec OREO.dbo.usp_GenerateTmpPivot')
Here is the error (Cannot process the object "SET FMTONLY OFF exec OREO.dbo.usp_GenerateTmpPivot". The OLE DB provider "SQLNCLI" for linked server "ccbdata01" indicates that either the object has no columns or the current user does not have permissions on that object.
)
Thank you
MaryJDoane