Re: [Emerald] Change object owner in MSSQL
Dale E. Reed Jr. ( (no email) )
Tue, 09 Feb 1999 13:09:15 -0800
Griswold Wayne wrote:
> 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
> How do I edit those objects to change the owner so that I can Drop the
> login ID in question?
I don't know if you can. The owner of the object is the person who
it (typically dbo, the database owner). You would probably have to drop
the objects and re-create them as dbo.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html