A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is

Title: How to Create an Application Role in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of creating an application role in Microsoft SQL Server 2000. Application roles are the SQL Server roles created to support the security needs of an application. Often database applications enforce their own security based on the application logic. For example, you can use application role with its own password to allow the particular user to obtain and modify any data only during specific hours. So, you can realize more complex security management within the application logic.

If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.