Displays properties for the selected workflow process. You can change the name of a workflow process, view the tables involved with the workflow process, and set certain options for the workflow.
Workflow Process Name
Displays the name of the selected workflow process. You can change it by typing a new name in the text box.
Workflow Table
Displays the name of the table used to create the workflow process. Read-only.
Workflow Actions Table
Displays the name of the table used to store information about the actions used in the workflow process. Read-only.
Workflow Lookup Table
Displays the name of the table used to store the workflow state names. Read-only.
Base User Table
Displays the name of the table that stores the data upon which the workflow process operates. Read-only.
Workflow State Column
Displays the name of the column in the base table that contains status of each row in the workflow process. Read-only.
Run workflow in a separate process
If cleared, the workflow engine runs in the same Microsoft Windows NTŪ process as SQL Server. If selected, it runs in its own process on the server, isolating it from the SQL Server process. Running the workflow engine in the same process as SQL Server provides better performance, but errors in your workflow script could interfere with SQL Server.
It is recommended you run the workflow engine in a separate process until you have fully debugged and tested your workflow process.
Enable workflow processing
Clearing this option disables workflow processing on the associated base table, which makes it possible for database updates to be made that do not conform to the workflow rules.
Use this setting if you want to suspend workflow processing while you make corrections to data in the table.
Make deleted rows available to script
If selected, the data values in a row prior to a user update, delete, or insert are available to workflow script through the Session object. Then, your script can compare values in the updated row with their original values to perform validation or other processing. Disable this option if you do not require deleted rows in your script to improve performance.
| For information about | See |
| Defining a table hierarchy for your solution database to make tables available for the workflow process | Setting up a Table Hierarchy |
| Adding a workflow process to your solution | Building a Workflow Process |
| Working with workflow states | Adding and Modifying States in a Workflow |
| Working with actions associated with workflow states | Adding and Modifying Actions for States |