Stored Procedures
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
The Access Workflow Designer server components contain solution system-stored procedures. The stored procedures implement key solution actions and provide a consistent set of primitives for developers who want to modify team solutions using generic database clients.
The action of the solution-stored procedures is limited to managing the schema, permissions, and administration tasks of solutions databases. It does not provide support for inserting data, such as workflow steps or lookup values, into user tables. Insert operations such as these should be done using Transact SQL.
For more information about stored procedures and triggers, see the SQL Server Books Online.
Schema Administration Procedures
The following procedures perform basic functions for the solution database, such as creating and removing database objects and setting properties.
| Procedure | Database | Comments |
| modAddTable | Solution | Registers a user table in the solution database schema. |
| modCreateProcedures | modSystem | Creates the stored procedures in a solution database. |
| modCreateSchema | modSystem | Creates the core tables and views in a solution database. |
| modDropProcedures | modSystem | Removes all the solution stored procedures from a solution database. |
| modDropSchema | modSystem | Removes all the tables and views from a solution database. |
| modGetProperty | modSystem | Returns a property in a solution table. |
| modInsertObjects | Solution | Adds an entry in the modObjects table. |
| modProcessTable | Solution | Adds core features to a user table. |
| modRemoveAllGrizzlyObjects | Solution | Cleans up all core features for a user table. |
| modRemoveTable | Solution | Removes the registration of a user table. |
| modSetProperty | modSystem | Sets a property in a solution table. |
| modSyncUserList | modSystem | Synchronizes the User Directory in the modUserList table. |
Solution Information Procedures
The following procedures return information about the team solution and its users.
| Procedure | Database | Comments |
| modGetAppInfo | modSystem | Returns registration properties for a specified solution. |
| modListApplications | modSystem | Lists all registered team solutions. |
| modListTemplates | modSystem | Lists all registered templates. |
| modUserExists | modSystem | Tests the existence of a specific user. |
Workflow Procedures
The following procedures perform actions related to the workflow process.
| Procedure | Database | Comments |
| modExecuteTimeoutEvents | modSystem | Executes time-out events in solution databases registered on the server. |
| modRemoveWorkflow | Solution | Removes the workflow registration for a user table. |
| xp_modWfDrop | Master | Discards the information cached by the workflow engine. |
| xp_modWfShutdown | Master | Stops the workflow engine component. |
Security Procedures
The following procedures validate and perform actions related to security features for row-level permissions and workflow actions.
| Procedure | Database | Comments |
| modDropRowPermissions | Solution | Removes row-level permissions for a database role or for all roles. |
| modEnumRowPermissions | Solution | Lists row-level permissions for a database role. |
| modGetExecutePermissions | Solution | Tests to determine whether a user has execute permissions on a workflow action. |
| modGetPermissionsJoinColumn | Solution | Returns the name of the numeric column used to uniquely identify the row in the permissions table. |
| modGrantRowPermissions | Solution | Sets row-level permissions for a database role. |