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

Smart Rename: TRY ... CATCH,

EdmundEdmund Posts: 11
edited July 21, 2011 2:10PM in SQL Prompt Previous Versions
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

Comments

Sign In or Register to comment.