Administration Samples

The administration samples demonstrate the use of administrative features, such as event notifications, partitioning, filegroups, and alerts.

The topics in this section contain the text of the readme files for the administration samples. To view or work with these samples, make sure they have been installed. For more information, see Installing Samples.

Name Description

Event Notifications Sample

Demonstrates how event notifications can be used in an OLTP database application.

Readme_PartitioningScript

Demonstrates the table and index partitioning capabilities of Microsoft SQL Server 2005.

Readme_SlidingWindow

Demonstrates the ability to move partitions between tables by using the Transact-SQL ALTER TABLE SWITCH statement.

Readme_AdventureWorksScripts

Provides two alternatives to using the schemas in the AdventureWorks sample database.

Readme_FileGroups

Demonstrates filegroup and file capabilities in SQL Server 2005.

Readme_Snapshot

Demonstrates the database snapshot capabilities of SQL Server 2005.

Readme_Alerts

Demonstrates the alert capabilities of SQL Server 2005.

Important

These samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples.

See Also

Other Resources

Running Setup to Install AdventureWorks Sample Databases and Samples
Reinstalling Sample Databases from Script

Help and Information

Getting SQL Server 2005 Assistance