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
> VerifyNTMUser.
> 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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |

For more information about this list, including removal,please see