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

can we turn off transactions in smart rename

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?
Mickeal Davis
Enterprise Architect
City of Swan
Western Australia

Best Answer

  • Options
    Eddie DEddie D Posts: 1,789 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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.