Dropping SQL Server database results in the message "only user processes can be killed"

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Attempt to drop a SQL Server 2008 Database

What is the expected output? What do you see instead?

Database should be dropped. Instead an exception is thrown with the message
"only user processes can be killed"

What version of the product are you using? On what operating system?

Head / Windows 7 / SQL Server 2008

Please provide any additional information below.

Tarantino attempts to drop all active PIDs. Per this thread, only PID's
over 50 should be attempted.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/243fba41-4894-4
1f4-a1a8-ab7421fa5452

A modified sql file to correct this is attached. An alternative might be
the alternative query suggested in the thread.

Original issue reported on code.google.com by brian%ac...@gtempaccount.com on 21 Jun 2009 at 10:46

Attachments:

• DropConnections.sql

[GoogleCodeExporter]

I"m having the same problem.  Help me obi-wan-palermo...you're my only hope.

Original comment by fregas@gmail.com on 23 Oct 2009 at 7:04

[GoogleCodeExporter]

This is fixed in the trunk.  Get latest version.

Original comment by jeffreyp...@gmail.com on 23 Oct 2009 at 7:27

[GoogleCodeExporter]

Original comment by jeffreyp...@gmail.com on 23 Oct 2009 at 7:28

• Changed state: Fixed