Issue 6 in tarantino: Dropping SQL Server database results in the message "only user processes can be killed"

[codesite...@google.com]

Status: New
Owner: ----

New issue 6 by br...@accessity.net: Dropping SQL Server database results in
the message "only user processes can be killed"
http://code.google.com/p/tarantino/issues/detail?id=6

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-41f4-a1a8-ab7421fa5452

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

Attachments:
DropConnections.sql 718 bytes

--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings

[codesite...@google.com]

Comment #1 on issue 6 by fregas: Dropping SQL Server database results in

the message "only user processes can be killed"
http://code.google.com/p/tarantino/issues/detail?id=6

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

[codesite...@google.com]

Comment #2 on issue 6 by jeffreypalermo: Dropping SQL Server database

results in the message "only user processes can be killed"
http://code.google.com/p/tarantino/issues/detail?id=6

This is fixed in the trunk. Get latest version.