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.
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!