Re: Table with no owner

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 05/26/04 

Date: Wed, 26 May 2004 13:31:09 -0400

D,

You got through it by Hari's suggestion, so great. However, I prefer to
avoid updating system tables when possible. I have had this happen a couple
of times, so here was my situation.

1. Looking in sysobjects revealed that there was uid with a non-NULL value.
2. There was no entry in sysusers with that number.
    In all cases that I have caught (just a handful) the highest uid was 1
below the missing uid.
3. Add a user to the database. If the uid matches the sysobjects uid then
the objects are now owned.
4. Delete the objects
5. Delete the user

The only database that I have had this problem in is one that is being
created / modified using Access 2000.

Russell Fields

"D" <anonymous@discussions.microsoft.com> wrote in message
news:1246e01c442a3$2865a8f0$a401280a@phx.gbl...
> We have two tables that somehow got created with no owner
> listed. When I try to delete the table, I get the
> message "Error 21776:[SQL-DMO]The name "tablename" was
> not found in the (null) collection."
> I can't change the object owner without a current owner.
> How can I delete these tables?

Relevant Pages