Export to GitHub

tarantino - issue #6

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


Posted on Jun 21, 2009 by Happy Giraffe

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

Comment #1

Posted on Oct 23, 2009 by Swift Bear

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

Comment #2

Posted on Oct 23, 2009 by Swift Bear

This is fixed in the trunk. Get latest version.

Comment #3

Posted on Oct 23, 2009 by Swift Bear

(No comment was entered for this change.)

Status: Fixed