Share via

modCreateProcedures

  • Article

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.

Installs all the Workflow Designer for SQL Server stored procedures in a workflow-enabled database. Exists in the modSystem database.

[@DBName =] 'dbname',
[@OverWrite =] 'False'

Parameters

  • [@DBName =] 'dbname'
    Name of the workflow-enabled database.
  • [@OverWrite =] 'False'
    Indicates whether the stored procedure should overwrite existing stored procedures. When False (default), the procedure produces an error if any application stored procedure is found in the database. When True, the procedure replaces any existing stored procedures.

Remarks

Creates all the mod* stored procedures.

Example

The following example creates Workflow Designer for SQL Server stored procedures in the current Issue Tracking sample database and overwrites existing stored procedures:

EXEC modCreateSchema 'IssueTracking', 'True'

See Also

Stored Procedures | Workflow Application Infrastructure | ModSystem Database Tables | Workflow-Enabled Database Tables | Views