Four part naming anyone? Does anyone ever do that? I use three part naming when shifting stuff around different DBs on the same server quite often.

My tip for those, like me, who have to perform lots of CRUD ops on production databases is to always write your query as a "Select" first to check what you are going to insert/update/delete/screw up!. If you are not sure that the results of your "Select" are what you are expecting then double check it (store a copy somewhere so you can recover it easily). Only change your query to the update/delete/insert at the very end when you are 100 percent confident that it is doing what you want. Even then you will make mistakes because your expectations were incorrect.

Always consider how you will undo/retrieve/fix what you have done before you do it!

I do development and also have to manage and update live data. I wouldn't use a different account/connection each time it's just not practical.