Export (0) Print
Expand All

Administration Samples

SQL Server 2005

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.

ms160726.note(en-US,SQL.90).gifImportant:
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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft