Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    7

    Unanswered: resetting master.mdf

    Hey! I downloaded the sql engine and made a bunch of tables in visual basic. They were called new1, new2, new3, and new4. So I deleted new1.mdf, new1.ldf, new2.mdf, etc... but I notice I still can't recreate them. So I'm thinking there's remnants in master.mdf or something?? How would I go about getting rid of all the old tables, even ones whose names I've forgotten, so I can have a clean slate again? (btw I don't have sql server, just the desktop engine)

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    mdf's are not tables..they are databases....

    Did you DROP the databases?

    If so they are gone.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2004
    Posts
    7
    thanks for the quick reply. I didn't drop the databases. In the VB code all I did was 'create database... etc'. So, how would I drop all the databases, even if I don't remember the names of all of the ones that I created? Like is there a way to reset all that stuff so it will be like I just installed it?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    SELECT * FROM master..sysdatabases

    Just don't touch master, msdb, model, pubs or northwind


    And you probably should do some maintenance

    Check out

    http://weblogs.sqlteam.com/tarad/arc...7/02/1705.aspx
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Aug 2004
    Posts
    7
    thanks! I'll check that site out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •