Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Eli Leiba Methods For Converting a Stored Procedure RE: Methods For Converting a Stored Procedure

  • October 29, 2009 at 9:39 am

    #1072557

    Ramon-218872 (10/29/2009)

    Hi to all,

    I'm trying to use the code, because it's that I need, but I get the error:

    Msg 7357, Level 16, State 2, Procedure sp_ConvProc2View, Line 27

    Cannot process the object "SET FMTONLY OFF EXEC 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 body can help me?

    Thanks in advance...

    Do you have exec permssions on the stored procedure with the name sp_ControlStock?

    i.e. if you type 'EXEC sp_ControlStock' (with no parameters) does that return you some rows?