Smart Rename: TRY ... CATCH,
Edmund
Posts: 11
Good day Red Gate,
I'm looking into using the Smart Rename feature to change the schema of a few objects and have all the dependent objects updated. They are a few base objects that are used in may locations and Smart Rename is going to save us a lot of time.
@TRANCOUNT IF statements the start and end transactions. It is very hard to track what will or wont be committed. It breaks up the script into multiple transactions that commit as it goes. It seems that some of the script will commit and some will not. I think it is safer for everything to commit or nothing to commit.
@TRANCOUNT IF statements. Also, an option that rolls back the entire script on any error. The current script is very confusing to follow concerning what will happen with the transactions.
Thanks,
Edmund
I'm looking into using the Smart Rename feature to change the schema of a few objects and have all the dependent objects updated. They are a few base objects that are used in may locations and Smart Rename is going to save us a lot of time.
@TRANCOUNT IF statements the start and end transactions. It is very hard to track what will or wont be committed. It breaks up the script into multiple transactions that commit as it goes. It seems that some of the script will commit and some will not. I think it is safer for everything to commit or nothing to commit.
@TRANCOUNT IF statements. Also, an option that rolls back the entire script on any error. The current script is very confusing to follow concerning what will happen with the transactions.
Thanks,
Edmund
Comments
You may want to add it on our SQL Prompt Feature Request forum, here: http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
Then, other users can also vote on this if they find it important, and we can gauge the amount of interest in it.
Redgate Software