A place to store and find useful snippets of SQL code.
Scenario: Trying to drop a database user, and get an error about not being able to change db_owner.
Solution: Update the db_owner to be owned by sa.
EXEC sp_changedbowner 'sa'
Leave a comment | tags: Security, T-SQL, Users | posted in Security, T-SQL, Users
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Join 3 other followers
Sign me up!