Template Contents
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.
A template created for a workflow application incorporates a broad range of contents. When you use the SQL Server Workflow Template Creation wizard to create a workflow application template, you incorporate the workflow process, the database, and the Web site.
To complete the Template Creation wizard, you provide a template name and description, select any data you want to exclude from the database tables in the template, and specify whether existing database users should be excluded from the template.
Then, the wizard invokes a server COM object (the template management object) to create a copy of the database, truncate the selected tables, remove the database users if desired, and to store a copy or backup of this database into a template components table created for the template. The Web site (as registered in the modApplications table in the modSystem database) is enumerated, and every file is stored as a template component along with a relative URL to restore it to its original relative location on deployment. The template is added to the modTemplates table in modSystem, so it appears in the list of installable templates on the server.
Database
To truncate user tables and remove database users, a temporary copy of the workflow-enabled database is created on the server. This database is created in the environment's temp directory. The COM template manager object runs under the context of the user who invokes it. To succeed at creating the template, you must be a member of the modAppOwners group.
Template Information
The template name, title, description, and version information is stored in a new row in the modTemplates table in the modSystem database. If you overwrite an existing template with another that has the same name and version, then the old row in the modTemplates table is deleted, along with its associated template components table.
In addition to this information, the template stores Microsoft® SQL Server™ configuration information. When you create a template, the configuration of the server where the template is made is stored in the template. If you deploy the template to a server with different configuration settings, a message will warn you of possible issues.
See Also
Developing Workflow Applications for SQL Server | Creating Templates | Creating a Template for a Workflow Application for SQL Server | Saving a Template to a Server | Testing a Template