Adventure Works SQL Server 2005 SP2a sample databases

Here you can find all sample databases:

Visit the SQL Server Samples and Community Projects page on CodePlex at:

http://codeplex.com/SqlServerSamples 

For those people who looking something specific as follow the same link above, you can see the original names of databases below. And also you can see step by step manual how to install and attach database to your SQL server.

 

AdventureWorks - AdventureWorksDB.msi 

AdventureWorksDW - AdventureWorksBI.msi 

Northwind and pubs Sample Databases for SQL Server 2000 Download

(by default after installation completed you can find northwind database, under this location

C:\SQL Server 2000 Sample Databases\. For installation in more detail click here)

 

First Step. Download the file you need. Install (by default it will install it C:\Program Files\Microsoft SQL server\MSSQL.1\MSSQL\Data\nameofdatabase.mdf)

 

Next Step. Open SQL server, right click on Databases (on your left). Select Attach then press add button. Select database that you need and press OK.

 

Feature '75a0fea7-cd50-401e-af0e-782f3662a299' is not installed in this farm, and can not be added to this scope.

When I was trying to create Top-Level site using "Help Desk" template I got next error "Feature '75a0fea7-cd50-401e-af0e-782f3662a299' is not installed in this farm, and can not be added to this scope"

One of the ways to resolve this issue to install Windows SharePoint Services 3.0 Application Template: Application Template Core.

Install:

stsadm -o addsolution -filename path\mySolution.wsp

stsadm -o execadmsvcjobs

stsadm -o deploysolution -name mySolution.wsp -immediate -allowGacDeployment -force

Uninstall:

stsadm -o retractsolution -name mySolution.wsp -immediate

stsadm -o execadmsvcjobs

stsadm -o deletesolution -name mySolution.wsp -override

stsadm -o execadmsvcjobs

Web Template IDs in Sharepoint

STS#0 Team site
STS#1 Blank site
STS#2 Document workspace
MPS#0 Basic meeting workspace
MPS#1 Blank meeting workspace
MPS#2 Decision meeting workspace
MPS#3 Social meeting workspace
MPS#4 Multipage meeting workspace
WIKI#0 Wiki
BLOG#0 Blog

BDR#0 Document center—A central document management location for an enterprise
OFFILE#0 Records center—A central location in which records
OFFILE#1 managers can define routes for incoming files
CMSPUBLISHING#0 Publishing site
BLANKINTERNET#0 Publishing site—A site for publishing web pages on a schedule with workflow features enabled
BLANKINTERNET#1 Press releases site
BLANKINTERNET#2 Publishing site with workflow—A publishing site for web pages using approval workflows
SPSNHOME#0 A site for publishing news and articles
SPSREPORTCENTER#0 Report center—A site for creating, managing, and delivering web pages, dashboards, and Key Performance Indicators (KPIs)
SPSPORTAL#0 A starter hierarchy for an intranet divisional portal
PROFILES#0 A profile site that includes page layouts with zones
BLANKINTERNETCONTAINER#0 Publishing portal—a site collection preconfigured for revision-controlled, secure content creation and publication

BDR#0 Document center—A central document management location for an enterprise
OFFILE#0 Records center—A central location in which records
OFFILE#1 managers can define routes for incoming files
CMSPUBLISHING#0 Publishing site
BLANKINTERNET#0 Publishing site—A site for publishing web pages on a schedule with workflow features enabled
BLANKINTERNET#1 Press releases site
BLANKINTERNET#2 Publishing site with workflow—A publishing site for web pages using approval workflows
SPSNHOME#0 A site for publishing news and articles
SPSREPORTCENTER#0 Report center—A site for creating, managing, and delivering web pages, dashboards, and Key Performance Indicators (KPIs)
SPSPORTAL#0 A starter hierarchy for an intranet divisional portal
PROFILES#0 A profile site that includes page layouts with zones
BLANKINTERNETCONTAINER#0 Publishing portal—a site collection preconfigured for revision-controlled, secure content creation and publication