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.


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


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


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


Demonstrates filegroup and file capabilities in SQL Server 2005.


Demonstrates the database snapshot capabilities of SQL Server 2005.


Demonstrates the alert capabilities of SQL Server 2005.


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