• Yes I can exec sp_ControlStock without problems...

    I make some tests:

    exec SGANPS.dbo.sp_ControlStock

    It works

    SELECT *

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

    'SELECT *

    FROM SGANPS.dbo.ARTICULOS');

    It works

    SELECT *

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

    'exec SGANPS.dbo.sp_ControlStock');

    Msg 7357, Level 16, State 2, Line 1

    Cannot process the object "exec SGANPS.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.

    Some suggestion?

    Thanks in advance