Richard Comito
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
that would do it.Would do what?
It was only a matter of using the wrong SP name?
ASKER
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!
Thanks, guys!
ASKER
Thanks,
Rich