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

Title: How to Get Information About a View in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of getting information about a view in Microsoft SQL Server 2000. You can gain information about the definition of a view if it is not encrypted. You may need to see the definition of the view to understand how its data is derived from the source tables or to see the data defined by the view. Views are queried the same way that ordinary tables are queried. However, any table hints used when querying the view are ignored.

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