Slight issue: We setup a machine with one name, and setup databases. Then we renamed the machine and the username for the dbo user is the OLDMACHINEName\administrator. I want to change this to the NEWMACHINENAME\administrator since this is causing issues with the sql agent jobs. Can I just run a sp_Changedboowner?
Thanks,
Neil