Hi,

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

'exec .dbo.sp_who');

It works

But:

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=.;Trusted_Connection=yes;',

'exec .dbo.sp_ControlStock');

Gets:

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "exec .dbo.sp_ControlStock". The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.