One of our databases was created with a user that we no longer
want to use. I cannot drop the user because it owns one of the
dbs and some other objects.
Is there a way to change ownership, or REVOKE all of the owners
privileges and give them to another user, so I can drop that
user?
/mark