I have found a way to remove some of my nagging processes that I deployed in Development that I am never going to use again. Either I was simply annoyed by the fact that it is in the list of deployed processes to choose from or I wanted to make sure that process never ran again.
I went into two Databases, nK2Server].]dbo].]_ProcInst] and d_ProcSet].
Searched for my process and deleted it from _ProcSet. I deleted the ones in _ProcInst as well because I had over 100 instances in Error state and I didn't want to delete them 1 by 1.
This method has removed all my running instances of that Process and also removed the Process from my list of deployed Processes to manage in a portal site. However, a portal site that was configured to watch that process still shows my deleted process (at the bottom where it shows the columns: Running, Stopped, Error and All). Does anyone know how I can remove the process from that list? I know if I unchecked that process in the Settings for that portal site before removing from the DB I would have been good but this shows me that there are still entries in a DB with the Process name so I am hoping someone can lead me in the right direction to finding that other DB.
Thanks for the help,