• thedspaincrew - Tuesday, November 6, 2018 12:35 PM

    Comments posted to this topic are about the item String Replace in Stored Procedures with Powershell

    Not intended towards you but in general, the problem with the task
    " My task wasn't to find out why that was happening but to find a way to script out the SPs and replace the proper text and alter the procedures as it was causing an outage".
    So then with someone creating stored procedures with the setting off, they will need to run this every time that person deploys new stored procedures.
    Seems the client should have worked on understanding the issue and knowing they could check sys.sql_modules to find the settings for the stored procedures. If it was me, I'd want to know that I was screwing this up every time. And I'd learn things in the process.

    Sue