SQL Prompt is showing an old version of my stored procedure
telmop
Posts: 4 New member
Hi,
I'm using Sql Prompt Version 8.0.0.1241.
I have a procedure that was renamed 3 months ago. If I do "Script object as alter" on the procedure, it shows the old version, before the rename.
I tried refresh suggestions, no success.
If I do a SHIFT-F12 on the procedure, I get the correct version on the object explorer.
Could it be a bug?
PS: Forgot to mention that the old procedure name does not appear in the system tables.
I'm using Sql Prompt Version 8.0.0.1241.
I have a procedure that was renamed 3 months ago. If I do "Script object as alter" on the procedure, it shows the old version, before the rename.
I tried refresh suggestions, no success.
If I do a SHIFT-F12 on the procedure, I get the correct version on the object explorer.
Could it be a bug?
PS: Forgot to mention that the old procedure name does not appear in the system tables.
Tagged:
Comments
Thanks for your post! I've managed to reproduce this here but I could do with more information from you about how you renamed this procedure.
If you used 'sp_rename' be aware from the MSDN documentation here that it's not recommended and that may have caused the issue. If not then we'll have to look into it further
Thanks!
Redgate Software
Thanks for the quick reply.
I did the rename with sp_rename, and that caused the issue.
I will recreate the affected objects so we don't have an accidental loss of code.
Thanks!