Windows Workflow Foundation v4 Clear Instance Tables
March 9, 2010Sometimes you have to do what you have to do.
delete from [System.Activities.DurableInstancing].InstanceMetadataChangesTable delete from [System.Activities.DurableInstancing].InstancePromotedPropertiesTable delete from [System.Activities.DurableInstancing].InstancesTable delete from [System.Activities.DurableInstancing].KeysTable delete from [System.Activities.DurableInstancing].LockOwnersTable delete from [System.Activities.DurableInstancing].RunnableInstancesTable delete from [System.Activities.DurableInstancing].ServiceDeploymentsTable delete from [System.Activities.DurableInstancing].SqlWorkflowInstanceStoreVersionTable