What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt is showing an old version of my stored procedure

telmoptelmop Posts: 4 New member
edited May 22, 2017 11:36AM in SQL Prompt
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.
Tagged:

Comments

  • Options
    James RJames R Posts: 104 Silver 4
    edited May 23, 2017 8:27AM
    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!
    Software Engineer
    Redgate Software
  • Options
    telmoptelmop Posts: 4 New member
    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!
Sign In or Register to comment.