I have a single database instance. I have many schemas in it. If there is any DDL change (create / update / delete) in stored procedure or table for 1 schema, then I have to do that change in all other schemas on same database. Which is best method of doing that?
Powershell is a nice method for that kind of stuff
have you looked into DDL triggers?