Administration Samples
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than 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 Considerations for Installing SQL Server Samples and Sample Databases.
| Name | Description |
|---|---|
Demonstrates how event notifications can be used in an OLTP database application. |
|
Demonstrates the table and index partitioning capabilities of SQL Server. |
|
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 AdventureWorks2008R2 sample database. |
|
Demonstrates filegroup and file capabilities in SQL Server. |
|
Demonstrates the database snapshot capabilities of SQL Server. |
|
Demonstrates the alert capabilities of SQL Server. |
Important
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. Sample applications and assemblies should not be connected to or used with your production SQL Server database or your report server without the permission of the system administrator.