The code samples and sample databases for SQL Server are no longer included with the product. Instead, you can locate and download the samples and sample databases from the Microsoft SQL Server Samples and Community Projects Web site at http://www.codeplex.com/sqlserversamples. In the tables organized by technology, there are hyperlinks to samples for the SQL Server components and to the official SQL Server sample databases. These tables also provide links to samples and projects that are available in the SQL Server community.
To install the complete set of product samples, on the Microsoft SQL Server Samples and Community Projects home page, click the Releases tab. Note that the default release for each project is the most current release. This might be a community technology preview release. To select a prior release, click the release name in the Release pane.
On CodePlex, you can locate specific projects for the product samples for a technology area of SQL Server (Analysis Services, Database Engine, Data Programmability, and so on) by clicking the link for the technology you want in the technology area table of the Microsoft SQL Server Samples and Community Projects home page at http://www.codeplex.com/sqlserversamples. In each specific project, click the Releases tab, and then click the Windows Installer package to download the set of samples in that technology area. To view the code for samples in that technology area, click the Source Code tab, and then click the folder icon in the Browse column.
If you choose to install the samples, by default, the sample files are installed in the following location: C:\Program Files\Microsoft SQL Server\100\Samples\<technology_name>.
If you currently have samples for SQL Server 2008 installed, you need to uninstall these samples before you install samples for SQL Server 2008 R2. Otherwise, the samples for SQL Server 2008 R2 will not install successfully.
To install the official sample databases for SQL Server, go to http://www.CodePlex.com/MSFTDBProdSamples.Or, on the Microsoft SQL Server Samples and Community Projects home page, in the Sample Databases section, click the Download link and select the databases that you want.
Http://connect.microsoft.com and CodePlex provide a direct way to report issues and ask questions about the samples for each technology area. To report problems and review the status of issues that you have reported, file a bug at Http://connect.microsoft.com. To discuss various sample ideas, provide feedback about existing samples, or ask questions about the samples, click the Discussions tab at Http://Connect.Microsoft.com/SqlServerSamples or one of the related projects. Please do not use the Issues tab on CodePlex to report samples defects.
Before you compile Microsoft .NET Framework common language runtime (CLR) samples for SQL Server, verify that the path of the version of the .NET Framework compiler is the first Framework directory in the PATH environment variable. The location of the compiler that is shipped with this release of SQL Server is C:\<Windows root directory>\Microsoft.NET\Framework\v2.0.x. Drive C is the installation drive, <Windows root directory> is either Windows or WINNT, and x is five digits.