trying to delete

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

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


"rodchar" <rodchar@discussions.microsoft.com> wrote in message
news:5E58AED5-8264-4BE3-8EA1- 1AA30851E90D@microso
ft.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