Try below updated query;

I Just added a set option (FMTONLY) before procedure execution

[Code="sql"]

select A.*

FROM

OPENROWSET ('SQLNCLI10','server=ABCD;trusted_connection=yes',

'SET FMTONLY OFF EXEC [SP_SQL_Database_Details_STASQL1_ToReport]')as A

[/code]