Check to make sure that the owner of the stored procedure is accessible from the sql server login. for example, all the others may be dbo.DSC_..... while this one could be mylogin.DSC_.... You can use the sp_changeobjectowner 'objectname','ownername' to change it to match the other items.
|