Hi all,

Within SQL Server, I'm trying to find out which schema and table K2 Studio refers to to grab the auto-incrementing Process Instance ID.

Background:

I need to find this because there have been occasions where I needed rollback the K2 database to the previous day's backup (due to unexplained DB corruption). Upon the rollback, the Process Instance ID value is also rolled back. This causes issues in our operations because old Process Instance ID values - which are already used in our other, non-corrupted database - reused in new records. Thus, we have multiple smartforms with the same Process Instance ID.