Post reply

Phantom Table?

  • November 21, 2007 at 3:51 am

    #73865

    Hi

    We have a strange issue in our database:

    There is a table, visible in the SQL Enterprise Manager, which cannot be deleted.

    From within SQL/EM we get an error message:

    Error 21776: [SQL-DMO] The name 'UserPrefTypes' was not found in the (null) collection. If the name is a qualified name, use [] to separate various parts of the name and try again.

    From within SQL/QA when we execute the statement DROP TABLE UserPrefTypes we get the error message:

    Server: Msg 3701, Level 11, State 5, Line 3

    Cannot drop the table 'UserPrefTypes', because it does not exist in the system catalog.

    I suspect there's something wrong with the ownership of this table: this table shows up in the QA as 'UserPrefTypes' rather than dbo.UserPrefTypes.

    HELP!

    Regards, Frank

  • November 21, 2007 at 5:57 am

    #753057

    I managed to get rid of this "phantom" table by checking the "Allow modifications to be made directly to the system catalogs" option in Server Settings tab.

    After that I executed

    DELETE FROM sysobjects WHERE Name = 'UserPrefTypes'

    Problem fixed.

    P.S. Don't forget to uncheck the option afterward 😀

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply