SQL Server 2005 Samples and Sample Databases (February 2007)
Brief Description
Download over 100 samples and five sample databases for SQL Server 2005.
On This Page
Quick Details
| Version: | 9.00.3042 |
| Date Published: | 2/19/2007 |
| Language: | English |
| Download Size: | 24 KB - 234 |
| *Download size depends on selected download components. | |
Overview
The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components:
Since its original release, new samples have been added for the following technologies: Analysis Services, CLR, SMO, Integration Services, Replication, and Reporting Services. See the SQLServerDatabasesAndSamplesOverview.htm file for descriptions of the new and original samples.
Note The February 2007 release is compatible with SQL Server 2005 SP2. There are several new samples in this release, and many bugs fixes. See the SQLServerDatabasesAndSamplesOverview.htm file for a description of the new samples available in this release.
- Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
- Analysis Services
- Integration Services
- Notification Services
- Reporting Services
- Replication
Since its original release, new samples have been added for the following technologies: Analysis Services, CLR, SMO, Integration Services, Replication, and Reporting Services. See the SQLServerDatabasesAndSamplesOverview.htm file for descriptions of the new and original samples.
Note The February 2007 release is compatible with SQL Server 2005 SP2. There are several new samples in this release, and many bugs fixes. See the SQLServerDatabasesAndSamplesOverview.htm file for a description of the new samples available in this release.
System Requirements
- Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2
Instructions
The samples and sample databases are provided for three different processor types. Download the files most appropriate for you. The overview documentation .htm file is for all processor types.
Step 1: Before installing any of the AdventureWorks sample databases, completely remove previous installations of the corresponding database. To remove the previous installations, follow the instructions in the updated SQLServerDatabasesAndSamplesOverview.htm file below.
Step 2: Click the file you want to download from the list below. To install the samples, select SqlServerSamples.msi. To install the sample databases, select AdventureWorksDB.msi for the OLTP database and AdventureWorksBI.msi for the Analysis Services database and data warehouse.
Step 3: Do one of the following:
Step 1: Before installing any of the AdventureWorks sample databases, completely remove previous installations of the corresponding database. To remove the previous installations, follow the instructions in the updated SQLServerDatabasesAndSamplesOverview.htm file below.
Step 2: Click the file you want to download from the list below. To install the samples, select SqlServerSamples.msi. To install the sample databases, select AdventureWorksDB.msi for the OLTP database and AdventureWorksBI.msi for the Analysis Services database and data warehouse.
- x86
- SqlServerSamples.msi -- 25,469 KB
- AdventureWorksDB.msi -- 28,053 KB (case-sensitive collation)
- AdventureWorksDBCI.msi -- 29,177 KB (case-insensitive collation)
- AdventureWorksBI.msi -- 7,393 KB (case-sensitive collation)
- AdventureWorksBICI.msi -- 16,764 KB (case-insensitive collation)
- AdventureWorksLT.msi -- 2,251 KB
- x64
- SqlServerSamples_x64.msi -- 25,470 KB
- AdventureWorksDB_x64.msi -- 28,075 KB (case-sensitive collation)
- AdventureWorksDBCI_x64.msi -- 29,177 KB (case-insensitive collation)
- AdventureWorksBI_x64.msi -- 7,393 KB (case-sensitive collation)
- AdventureWorksBICI_x64.msi -- 9,021 KB (case-insensitive collation)
- AdventureWorksLT_x64.msi -- 2,251 KB
- Itanium (IA64)
- SqlServerSamples_IA64.msi -- 25,470 KB
- AdventureWorksDB_IA64.msi -- 28,075 KB (case-sensitive collation)
- AdventureWorksDBCI_IA64.msi -- 29,177 KB (case-insensitive collation)
- AdventureWorksBI_IA64.msi -- 7,409 KB (case-sensitive collation)
- AdventureWorksBICI_IA64.msi -- 8,979 KB (case-insensitive collation)
- AdventureWorksLT_IA64.msi -- 2,251 KB
Step 3: Do one of the following:
- To start the installation immediately, click Run.
- To save the download to your computer for installation at a later time, click Save.
- To cancel the installation, click Cancel.
Additional Information
For the latest on SQL Server 2005 Samples, visit the SQL Server Samples blog on MSDN.
Files in This Download
The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
| File Name: | File Size | |
|---|---|---|
GettingStartedWithSQLSamples.htm | 24 KB | |
SQLServerDatabasesAndSamplesOverview.htm | 211 KB |
What Others Are Downloading
Others who downloaded SQL Server 2005 Samples and Sample Databases (February 2007) also downloaded:
'DataBase' 카테고리의 다른 글
| 데이터베이스의 저장 프로시저를 자동으로 생성 (11) | 2007.04.06 |
|---|---|
| SQL Server 2005 온라인 설명서(2006년 7월) (0) | 2007.03.08 |
| 토드 사용시 실행계획 볼수 있도록 설정하는 법 (0) | 2007.03.07 |
| ms sql 에서 암호화 컬럼 (0) | 2007.01.19 |
| SQL Server 2005의 XQuery 소개 (0) | 2007.01.05 |
