I have migrated some databases to new server. As I need to change the owner of database to sa. I ran the script which I have to change all the databases owner to sa. But I did a mistake here, I ran it in source server instead of Target server. Does it going to be effect anything ?
I am confused now :/
Answer by KenJ ·
it's not going to be a problem unless you have some specific reason for the source databases to be owned by accounts *other than* 'sa' - perhaps a vendor system or something. You can change database owners to other accounts on a case-by-case basis if it causes any problems.
It's generally a good idea to set database ownership to 'sa', as you were planning to do on your new server.
Just run the script on the new server as you originally planned and call it a day.