Options

SQL Prompt Smart Rename and Split Table both include unrelated procedures

alphonsegalphonseg Posts: 34 Silver 1
in SQL Prompt
Using v 9.0.1.3179
I've just tried Smart Rename and Split table for the first time.
In both cases there are MANY procedures included in the script, that are not related to the table.
Am I missing some setting?
Tagged:
· Share on Twitter

Answers

  • Options
    krzysztofkroczakkrzysztofkroczak Posts: 55 Silver 2
    Hi @alphonseg,

    Thanks for letting us know. We don't have enough information to answer.
    Would it be possible for you to send us these scripts (either on the forums or by emailing it to us at sqlpromptteam@red-gate.com) that is not good in your opinion?

    Best regards,
    Krzysztof
    · Share on Twitter
  • Options
    alphonsegalphonseg Posts: 34 Silver 1
    Those would be proprietary. I did try it on a much simpler database and it only included the correct procedures. So, maybe it has to do with the amount of tables or procedures.
    · Share on Twitter
  • Options
    kkam99518kkam99518 Posts: 7 Bronze 3
    Hi,  I hadn't used Smart Rename for several months but when I attempted it today I had the same issue as noted above.

    The column I was attempting to rename is only referenced in 3 Procedures. 

    The generated script included 5 Functions, 12 Views, and 115 Procedures!

    Is there a setting in SQL Prompt that can narrow this down?
    · Share on Twitter
Sign In or Register to comment.