can we turn off transactions in smart rename
mickeal.davis
Posts: 10 Bronze 2
in SQL Prompt
I use a lot of synonyms with linbked servers and i have to commet out the transaction statements in the generated SQL from Smart Rename to prevent errors.
Is there a switch somewhere to turn off transactions?
Is there a switch somewhere to turn off transactions?
Mickeal Davis
Enterprise Architect
City of Swan
Western Australia
Enterprise Architect
City of Swan
Western Australia
Tagged:
Best Answer
-
Eddie D
Posts: 1,803 Rose Gold 5
Hi, thank you for your forum post.
When you use Smart Rename feature of SQL Prompt, the script generated to do the rename does include transactions.
Sadly there is no feature to turn off the use of transactions.
The workaround is to manually remove or comment out the transaction statements.
I recommend that you submit a feature suggestion in the SQL Prompt UserVoice forum using this link. Depending on the number of comments and votes the topic receives, will increases its chances of being included in a future version of SQL Prompt.
Many Thanks
Eddie
