trying to delete

15 Mar 2006 2:47 PM

rodchar

hey all,

i'm trying to delete a user from the users node in Enterprise Manager but
i'm getting a message like this:
---------------------------
Error
---------------------------
The selected user cannot be dropped because the user owns objects.
---------------------------
OK
---------------------------
What can i do to delete this user?

thanks,
rodchar

15 Mar 2006 3:19 PM

Keith Kratochvil

You need to find the objects that this user owns and use
sp_changeobjectowner to reassign ownership to a different user (perhaps
dbo).

--
Keith Kratochvil

Show quote

"rodchar" <rodc***@discussions.microsoft.com> wrote in message
news:5E58AED5-8264-4BE3-8EA1-1AA30851E90D@microsoft.com...
> hey all,
>
> i'm trying to delete a user from the users node in Enterprise Manager but
> i'm getting a message like this:
> ---------------------------
> Error
> ---------------------------
> The selected user cannot be dropped because the user owns objects.
> ---------------------------
> OK
> ---------------------------
> What can i do to delete this user?
>
> thanks,
> rodchar