Post reply

cannot drop database because it doesn''t exist in the system

  • May 3, 2005 at 8:39 am

    #87408

    I dropped a database using Enterprise Manager and it finished without generating any error. however it still shows up on E.M. When i try to delete it again, I got:

    'error 3701: cannot drop database because it doesn't exist in the system

    catalog'

     

    search the system database, no entry for the database in question.

    any remedy for this problem?

    thanks a lot for your help.

     

     

  • May 3, 2005 at 8:42 am

    #556541

    Can you try closing your Enterprise Manager Session and opening it back. Also Can you run sp_helpdb in query analyzer and see if the database comes up.

  • May 3, 2005 at 8:45 am

    #556544

    it is gone after closing EM. thanks

  • May 3, 2005 at 8:46 am

    #556545

    Or maybe just refreshing the db list...

  • May 3, 2005 at 8:47 am

    #556546

    i tried refresh before posting the question.

  • May 3, 2005 at 9:14 am

    #556556

    An restarting enterprise manager??

    Is there anything in the server's logs?

  • May 4, 2005 at 1:32 am

    #556674

    It is commonly known that the MMC console is unreliable.

    I have experienced several occasions where I have to close the EM/MMC console and open it again before primarily deletions shows up.

     

    Ib-Rene Kruse

  • March 10, 2006 at 8:48 am

    #626005

    Hello,

    I got the same error after deleting a load of tables.

    Refreshing didn't work at any level

    Exiting and entering fixed it and showed a table I couldn't see before which was actually causing me a problem else where...

    urgh... I say an Auto refresh should be implemented

     

    Ian

     

Viewing 8 posts - 1 through 7 (of 7 total)

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