Home Forums SQL Server 2005 Administering Created database but used Model RE: Created database but used Model

  • December 17, 2010 at 12:47 pm

    #1264217

    Kricky (12/17/2010)

    When I ran that query, I didn't get any results returned, so I will just let it finish. Thanks Adiga.

    kill it! kill it with fire!

    it doesn't matter what database scope you are currently in, a new database is always a copy of the model database;

    it should only take a second or two to complete, unless you make a mistake like alloting 1000 gigs instead of 10 meg or something...

    regardless, if it's been goign 12 hours, I'd kill it and start fresh.

    nothing good will come from a sql that has been that long running.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!