InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:28:31 GMT20http://www.sqlservercentral.com/Forums/Topic1036629-146-1.aspx[quote][b]Kricky (12/17/2010)[/b][hr]When I ran that query, I didn't get any results returned, so I will just let it finish. Thanks Adiga.[/quote][quote]kill it! kill it with fire![/quote]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.Fri, 17 Dec 2010 12:47:35 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1036629-146-1.aspxWhen I ran that query, I didn't get any results returned, so I will just let it finish. Thanks Adiga.Fri, 17 Dec 2010 12:23:30 GMTKrickyhttp://www.sqlservercentral.com/Forums/Topic1036629-146-1.aspxWhen the create database statement is running, it requires exclusive access to model database. Now that you have killed the sessions, do you see any other session blocking it?[code="sql"]select * from sys.dm_exec_requests where blocking_session_id<>0[/code]If that query is not causing any performance issues, you can wait for it to complete. Restarting the SQL Server is also an option but I don't think it will cause the MODEL database to go suspect.Fri, 17 Dec 2010 12:19:20 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic1036629-146-1.aspxHi all - I needed to create a database, but somehow my dropdown for the database that I was in in SSMS, had been selected as "model". I came back to see that the Create Database statement was still running long after I had started it. I have now killed that process, but it is still cancelling 12 hours later. What is the best solution on this? I am guessing that since the Model db is open, I cannot create any other databases until this query is stopped. If I stop and start SQL, I am concerned that my model db will come back as suspect. I am not an expert db administrator, and we don't really have one. Hard to search the web for this topic.Thanks.Fri, 17 Dec 2010 09:59:57 GMTKricky