Updating the Stored Procs with the New Schema Name After the Schema Migration RRS feed

  • Question

  • Dear Experts, 

    I just got some interesting requirement to update all the Stored procs / Functions / Triggers / Synonyms for my Newly created database where the Schema Migration was recently done from DBO to different other schemas. 

    Now to reflect these table names in all the Procs / Function .... we need to do the changes to the respective procs/functions...etc .

    I was curiously thinking whether there is any way to do this in an automated way. 

    Any suggestion related to this is really appreciated. 


    Thank you... MOMEN

    Wednesday, May 20, 2020 12:00 PM


All replies