Hi All...........

I have been asked to investigate a problem on a clients database. Using
enterprise manager, looking at the tables list within a database, there are
many tables with no owner assigned to them. The owner is blank. How the user
got to this situation I do not know. I have tried to drop these tables as
they are not needed, but I get an error back:

error 21776: the name was not found in the null collection.

I cannot drop through QA either.

Also tried to use sp_changeobjectowner procedure, but the error came back
the same. It seems that these tables do not exist but somehow still appear
in the table list.

So my question is how do I get rid of these tables or stop the names
appearing in the table list?

I have thought about exporting the tables with an owner, dropping the
database, recreating and re-importing those tables back, but it does seem a
little OTT.

Any ideas gratefully received...

Regards,


Sean Rodgers

MS Sql Server LazyDBA home page