Post reply

Can''t reattach db. How can I delete it through the back door ?

  • October 23, 2006 at 12:07 pm

    #174974

    I created a new db then deattached it, but after messing around with the physical files I cannot reattach any longer. I can't use Drop Database because it tells me that it either doesn't exist or I don't have permissions.

    select

    * from sys.sysdatabases  doesn't show the db because it was deattached. How can I delete the database permanently ? What system table do I need to modify manually to remove my db ?

    Thank you,

    Bob

  • October 23, 2006 at 12:37 pm

    #667439

    If your database is not attached to an instance, you can just delete the physical files through Windows Explorer. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • October 23, 2006 at 12:42 pm

    #667441

    Wow. Now why didn't I think of that ?

    It worked out just fine.

    Thank you,

    Bob

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

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