We had a domain user have the audacity to go and get married. Thus, she changed her last name. Unfortunately, we didn't create a new account for her with her new name....rather, we changed her login name (thus using the same SID). Well, now I need to add her to SQL security and I can't because her SID is listed and it shows her old name. When I try to delete her SQL login, it says I can't because she is the owner of database objects.
1. How do I display a list of objects and who owns them? (so I can change them to dbo)
or 2. Can I just update her username in the sysxlogins table to reflect the new Active Directory account information?