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

SQL Prompt Smart Rename and Split Table both include unrelated procedures

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?
alphonseg
0

Comments

3 comments

Sort by
  • krzysztofkroczak
    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
    krzysztofkroczak
    0
  • alphonseg
    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.
    alphonseg
    0
  • kkam99518
    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?
    kkam99518
    0

Add comment

Please sign in to leave a comment.