In their infinate wisdom, M$ has deemed that some processes are only allowed to be killed by users if
they were not started by the SYSTEM account.
We have several processes that may be started by SQLSERVERAGENT service and they are started
using the SYSTEM account and we need to kill them in order to install new versions. Let me say that
we have tried the Replace In-Use Files option and it doesn't work because we also want rollback
capabilities; we attempt to rename the directory that these utilites are in so we may rollback in case
Now, the rename isn't happening because of the in-use file(s) and we need to kill these processes if
they are running but none of the Kill Process scripts from the script library work. I have stepped
throught them and found that the error returned when trying to open the process to get the
process handle is "Access denied".
BTW, I am able to kill it using Task Manager because TM runs in the SYSTEM account.
Any thoughts on a solution or how to impersonate the SYSTEM account to kill these processes?