Link to home
Start Free TrialLog in
Avatar of Richard Comito
Richard ComitoFlag for United States of America

asked on

Cannot run stored procedure. but it is there.

I am getting this error; 'Could not find stored procedure 'UP_UPDATE_LOG.'' on two different servers with two separate instances of SQL. One instance is 2008r2, and the other is 2016.

I am logged in as SA for the following steps
     1)  I tried to execute the sp, but I get the error; 'Could not find stored procedure 'UP_UPDATE_LOG.''
          a. I even tried this with; execute dbname.dbo.UP_UPDATE_LOG
     2)  I tried to create the sp, and I get this error;  There is already an object named 'UP_LOG_UPDATE' in the database.
     3)  I tried to drop the sp, and I get; Cannot drop the procedure 'UP_UPDATE_LOG,' because it does not exist or you do not have permission.
     4)  I tried to alter the sp, and I get; Commands completed successfully.
     5)  So I tried steps 1 to 3 and got the same errors as before


Any suggestions of what is going on and how to fix this issue?  and this looks like it is only happening to this one stored procedure.

Thank you,

Rich
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard Comito

ASKER

Yep.  that would do it.

Thanks,

Rich
that would do it.
Would do what?
It was only a matter of using the wrong SP name?
Sorry for the long delay.  Been a crazy summer.  Yes, Vitor, that was my... I am embarrassed for asking a dumb questions response.

Thanks, guys!