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

SQL Prompt Smart rename is not finding dependencies.

SQL Prompt Smart rename is not finding dependencies. Is SQL Dependency tracker required for this or should SQL Prompt stand-alone do it?
I've used it before in a previous workplace where the whole SQL toolbelt was available, and it was seamless.  Where I am now, I only have SQL Prompt (and am in the trial period).
MattB_SCA
0

Comments

3 comments

Sort by
  • squigley
    Hello Matt,
    SQL Dependency Tracker shouldn't be required for this feature, SQL Prompt should be able to do this on it's own.

    Can you confirm if you're seeing this issue on the query script that's created or during the process to create said script? What version of SQL Prompt are you seeing this under?
    squigley
    0
  • MattB_SCA
    I'm seeing it in both areas. The creation part shows nothing expect the table the column to be renamed is in and Dependencies shows no dependant objects, even though they exist.  
    Once created, the script only mentions the table the column is in, but no dependencies..
    MattB_SCA
    0
  • squigley
    Hello Matt,
    Thanks for those additional details and screenshot.
    Can you confirm if you're seeing this across all of your databases or only particular ones? Can you go into more detail on how the dependencies reference the column being renamed?
    squigley
    0

Add comment

Please sign in to leave a comment.