removing a user from a database problem

I have followed the procedure in http://support.microsoft.com/kb/275312
to change object ownership so that I can delete a user.
This appears to have worked ( subsequent runs tell me that the
original user owns no objects and a query on the sysobjects table
filtered on their uid confirms this)
When I go to delete the user in enterprise manager it tells me that
the user still owns objects ( i have refreshed the view and even
exited EM to no effect)
I am using SQL server 2000 sp4
Any help much appreciated...
TIA
Hi
Have you tried sp_dropuser stored procedure in QA?
<pryan@.meticulus.com> wrote in message
news:1185880756.933653.204030@.19g2000hsx.googlegro ups.com...
>I have followed the procedure in http://support.microsoft.com/kb/275312
> to change object ownership so that I can delete a user.
> This appears to have worked ( subsequent runs tell me that the
> original user owns no objects and a query on the sysobjects table
> filtered on their uid confirms this)
> When I go to delete the user in enterprise manager it tells me that
> the user still owns objects ( i have refreshed the view and even
> exited EM to no effect)
> I am using SQL server 2000 sp4
> Any help much appreciated...
> TIA
>