We need to call a stored procedure through a SQL statement (i.e. SELECT * FROM OPENQUERY(SERVER, 'EXEC SP_CALL')) and are trying to resolve some issues. We are getting errors calling the stored procedure if the stored procedure uses temp tables (#Table) or table variables. We tried using SET FMTONLY OFF in the call without success. We have the server option set to allow Data Access. What other settings, syntax, etc is needed to get this to work?