How can we help you today? How can we help you today?

SQL Prompt is showing an old version of my stored procedure

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.
telmop
0

Comments

2 comments

Sort by
  • James R
    Hi @telmop ,

    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!
    James R
    0
  • telmop
    Hi James,

    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!
    telmop
    0

Add comment

Please sign in to leave a comment.