[Emerald] Change object owner in MSSQL

Griswold Wayne ( (no email) )
Tue, 9 Feb 1999 13:49:39 -0600

We are trying to remove a user (Drop) from the MSSQL6.5 Enterprise
Server Manager, however we receive the following message "You cannot drop
the selected login ID because that login ID owns objects in one or more
databases." Upon further poking around, it appears that the user in
questions "owns" the following objects: History, RadiusUsers, and
VerifyNTMUser.
How do I edit those objects to change the owner so that I can Drop the
login ID in question?

-Wayne

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html