--STEP ONE, SET DELETION STATE TO 2 SO THAT DELETION SERVICE WILL DELETE

--where objecttype in (4) "USE THIS TO REMOVE WORK FLOW FOR A SPECIFIC ENTITY

THERE IS A FULL LIST OF OBJECT TYPE CODES HERE

--STEP TWO, DELETE THE DEPENDENCIES

--select * from wfactionlog

--STEP THREE, DELETE THE DEPENDENCIES

--select * from wfrulelog

--STEP FOUR, YOU CAN RUN NOW RUN THE SQL BELOW TO DELETE THE PROCESS INSTANCE

--OR, YOU CAN USE THE DELETION SERVICE MOST COMMONLY FOUND AT THE FOLLOWING

--FILE PATH ON THE CRM SERVER

--C:\PROGRAM FILES\MICROSOFT CRM\SERVER\BIN

--ONCE IN THE DIRETORY, TYPE THE FOLLOWING COMMAND WITHOUT THE QUOTES "CRMDELETIONSERVICE.EXE /RUNONCE"