Michael L John - Thursday, May 18, 2017 12:09 PM
Ad hoc queries on a live server aren't an amazingly good idea, especially untested ones.
Better would be to test your script on the dev instance first with an approach of "do it", "check it", "roll back". Then check again with rollback on the live instance just in case something has changed, then run on live with a commit when you're absolutely happy.