|
Home > Archive > MS SQL Server Tools > March 2006 > trying to delete
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| rodchar 2006-03-15, 9:23 am |
| 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
| |
| Keith Kratochvil 2006-03-15, 9:23 am |
| 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
|
|
|
|
|