Planning Workflow Applications for SQL Server
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.
Planning is the key to developing successful workflow applications. Naturally, the database that stores the items to which you want to apply workflow is the centerpiece of your plan. This topic assumes you have created a database already and you are ready to add workflow to it. Based on the function of the database, you can identify the states that each item must pass through and the states that an item might pass through optionally or conditionally. Using the Workflow Designer for SQL Server, you can script events to control how items move from state to state through the workflow process.
In addition to the workflow process, you must develop a user interface and determine the various roles the application must have to control user interaction with data and database objects.
Workflow applications depend on the security and permissions provided by Microsoft® SQL Server™ and the operating system; these permissions and privileges must be reviewed carefully before beginning application development.
In This Section
- Workflow Application Development Guidelines
Review the design considerations for the database schema, scripting, and other aspects affecting a workflow application. - Security Permissions Model
Workflow Designer for SQL Server leverages Microsoft® Windows® 2000 and Microsoft® SQL Server™ security for its own security model. You can manage users and groups through the Windows 2000 Active Directory. - Database Tools and Technologies
Consider the features and capabilities of database tools Microsoft® Jet, Microsoft® SQL Server™ 2000 Desktop Engine, and Microsoft® SQL Server™. - The Workflow Engine Model
Understand how the workflow engine enforces the workflow process definition and executes workflow events.
Related Sections
- Developing Workflow Applications for SQL Server
Simplify the task of creating typical workflow applications, such as forms routing/approval, document review/publishing, and issue tracking, by using the workflow engine and specialized workflow modeling tools of the Workflow Designer of SQL Server. - Workflow Applications Architecture for SQL Server
Understand how the Workflow Designer for SQL Server and Workflow Services for SQL Server help you build, modify, and add script to workflow applications on a database. - Building Workflow Applications for SQL Server
Set up a table hierarchy, and build a workflow process for your workflow application. - Developing the User Interface for SQL Server
Create a web-based form that makes controlled access to the database possible through the workflow process. - Setting up Accounts, Logins, Roles and Users
Assign permissions to users through the workflow designer that complement the security of Microsoft® Windows® 2000 and Microsoft® SQL Server™. - Scripting Workflow Events for SQL Server
Add script to extend the capability and functionality of your workflow process. - Creating Templates
Store a complete workflow application in a reusable, transferable template. - Troubleshooting Workflow Applications for SQL Server
Find answers that help avoid or resolve the most common errors and issues you might encounter when using Workflow Designer for SQL Server.