SQL Server 2005 SP2a

Rating:        Based on 44 ratings
Reviewed:  40 reviews
Downloads: 287953
Released: May 7, 2007
Updated: May 7, 2007 by bonniefe
Dev status: -not yet defined by owner-

Recommended Download

Source Code SqlServerSamples.msi
source code, 25433K, uploaded May 7, 2007 - 255812 downloads

Other Available Downloads

Source Code SqlServerSamples_x64.msi
source code, 25433K, uploaded May 7, 2007 - 27381 downloads
Source Code SqlServerSamples_IA64.msi
source code, 25433K, uploaded May 7, 2007 - 4760 downloads

Release Notes

The complete set of SQL Server 2005 SP2 Product Samples for all technologies updated with the MS-PL license agreement. There are installers for each technology area in the release section of each individual Product Sample project as well if you are just interested in samples for a particular area of SQL Server.

Reviews for this release

hola a todos señores
by jonya1 on May 31, 2011 at 9:54 PM
Great product for overall development
by akoranteng on Jan 26, 2011 at 6:43 PM
To download Northwind for SQL Server 2005, go to this URL: http://www.joeblogs.ie/blog/post/Northwind-Database-for-SQL-Server-2005-Express.aspx
by derryart on Dec 2, 2010 at 8:05 PM
Where is Northwind ????????????????????? It is a waste of time seeing this site...................It sucks...................... by patricksusairaj on Apr 4 at 4:29 PM I neither.....
by kinogam on Dec 1, 2010 at 2:43 AM
Very good.
by dipaksaha on Nov 16, 2010 at 2:46 AM
The AdventureWorks database is not in a release state. There is no linkage between categories and products, a qualifier (Production) is required when building queries but the configure DataSource wizard is unaware of it unless you go into QueryBuilder to build the query (and, of course, the 'Configure Data Source' wizard cannot cope with Stored Procedures. Hopefully Northwind works.
by mklapp on Oct 21, 2010 at 4:17 PM
You can find the Northwind database in the Northwind and pubs Sample Databases for SQL Server 2000 webpage. There, in the Overview section, it says that such samples will work with SQL Server 2005, but that the AdventureWorks sample database is recommended for use with SQL Server 2005. This means that Northwind has been deprecated and therefore isn't a sample database anymore.
by carlos_mallen on Jun 8, 2010 at 7:01 PM
The reason people are looking for the NorthWind DB in SQL2005 is because examples, even by MS representatives, were still written to use the Northwind DB. See: http://blogs.msdn.com/b/sqlqueryprocessing/archive/2006/10/06/viewing-and-interpreting-showplan-xml.aspx
by Torquin on Jun 7, 2010 at 4:25 PM
Where is NORTHWIND? May I know if this is available? I can't find it after the install. SAD
by imperialx on May 20, 2010 at 11:29 AM
Where is Northwind ????????????????????? It is a waste of time seeing this site...................It sucks......................
by patricksusairaj on Apr 4, 2010 at 7:29 AM
Where is Northwind!!!!!!!!!!!!!!!!!!!!
by gangelo on Mar 2, 2010 at 1:53 PM
good job to work.
by kimisme on Dec 23, 2009 at 2:13 AM
The procedure I've seen is: install sql express, install sql server management studio express, install sql server samples. Then in studio click help->tutorial, scroll down to requirements and click the link on how to install the samples, scroll down to installation after setup and follow the instructions. Opps, nevermind, that procedure is NOT for the express edition.
by LinuxArchitect on Jul 15, 2009 at 3:18 PM
The adventure works samples are at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004 . God knows what this page is for. After installation look in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data for Adventure works. Go into Management Studiom right click on databases and Attach. Select the AdventureWorks_Data file.
by LarryK on Jun 8, 2009 at 1:08 PM
Downloaded this for the sample databases like Northwind and cannot find them.
by stucampbell on Jun 2, 2009 at 10:05 AM
I have installed Spatial DB it but the code for poly latlon only works for very large geographic area. I have tried creating small polygon and checking but none of them returns the corresponding points inside the polygon. It will be great, if anyone can help me with this.
by Dhanik on May 20, 2009 at 2:03 PM
cant see what your all complaining about. Presumabley you wanted to install somthing you couldn't find on your system already, after installing its now there! you wouldn't just choose to install the samples for no reason would you? just take your FREE samples and stop complaining about nowt!
by jonpen on Apr 24, 2009 at 10:26 AM
Why is an installation package needed for code samples and the sample database. There is no control over how the database is installed onto my server. Just a .bak file or .mdf to attach to would have been sufficient. Wrap this into a .zip file for us to pick and choose which components we would like to use. One size fits all is for suckers!
by Rudebags on Mar 26, 2009 at 8:52 PM
I was trying to download all day. Everytime, it stops at 3% and nothing happens after that. I tried from a different machine with same results.
by msami on Feb 23, 2009 at 5:51 PM
If you're looking for the Northwind database, this is not for you. Some general documentation would have made this a better package. Also a standard installation in the Program Files doesn't make sense to me, it's not an application.
by nmattheij on Feb 12, 2009 at 7:40 AM
Uh, ok. Only thanks to some nice people here I know where the installation is. But now, how do I use the examples? I would never touch a MS product again, if it weren't for my customers, binded to MS by monopoly. Why does microsoft always mean bad documentation? I just need a database with some tables and a connection string. Shouldn't take so long.
by loskobosko on Feb 2, 2009 at 10:10 AM
Good Stuff. There are few directories in Drive:\Program Files\Microsoft SQL Server\90\Samples directory. Go to bottom level in the folder hierarchy There is a readme.html file in every directory to see tutorial.
by Mahajan on Jan 28, 2009 at 6:54 PM
How do we reconcile the 5 star and 1 star ratings? Ans= Not so easy to find what you need, but when you do find it, it works great.
by MisterCaesar on Jan 28, 2009 at 4:22 PM
i can't download any of the files above.
by addin on Jan 27, 2009 at 7:03 AM
I am a newb I downloaded the SQLServerSamples.msi It goes into Program Files\Microsoft SQL Server\90\Samples\ by default When you run the msi it automatically adds the sample db to your MSS Management Studio in the Object Explorer in Databases in your default Server. No Management Studio? Installation error? - It won't add the workstation components of SQL2005 if you have SQLXpress b4 installing
by Arturian on Jan 23, 2009 at 6:58 AM
Anybody who can't figure this out needs to have their SQL Admin privileges revoked. It's amazing they found this web page in the first place.
by ID10TsAbound on Jan 20, 2009 at 2:32 PM
Linked from the installation DVD SQL Server 2008 looking for Adventureworks DB. It's not here MS! But here : http://www.codeplex.com/MSFTDBProdSamples
by hennie7863 on Jan 7, 2009 at 4:37 PM
No documentation...its been hard to replicate..
by kaaki on Jan 6, 2009 at 7:49 PM
I watched the folder the samples were to supposed to be extracted to ...no database .mdf files ever were copied / extracted to or otherwise put in that folder... I sure am gald I didn't pay money or give my credit card info YOU GUYS SUCK
by solus on Dec 27, 2008 at 7:26 PM
Designed to work with the tutorials in help. Good stuff!
by skeltech on Dec 8, 2008 at 7:30 PM
Definitely not for a newbie user such as myself. Difficult to find and work with files once you download them (or assume they downloaded correctly!)
by DanMan69 on Dec 8, 2008 at 2:21 PM
The absence of any documentation, or even the hint of where documentation might be found makes this worse than useless to the SQL Server newb. Presumable this package was put together with the express intention of detering beginners. You certainly suceeded with me. I won't bother visiting this awful site in future.
by b3nj1b0y on Nov 18, 2008 at 6:54 PM
This is great.
by aswanikarteek on Sep 26, 2008 at 11:10 AM
Easy to install. For those that like to click 'Next" without reading would miss where it was being installed. Maybe the finished screen should have a link to the location of where it was installed for those who miss it.
by cthames on Sep 23, 2008 at 5:17 PM
This was a horrid experience. I don't even know where to begin. I guess I'll start with the fact that this didn't install Northwnd. I would expect at least that. I mean, that was the whole point of installing the sample DBs. I'm sorry I can't give more useful advice, but the fact is you guys need to start over from ground zero. This is terrible.
by CodePlexSux on Sep 23, 2008 at 6:29 AM
Worked Great for me Thanks!
by jbeam on Sep 5, 2008 at 5:07 PM
no guidance, no documentation - does not follow the original installation at msdn - very poor
by fargamon on Aug 23, 2008 at 1:46 PM
Where are the SS2005 Sample Databases?
by jenisys on Aug 20, 2008 at 4:43 PM
Installation Path is C:\Program Files\Microsoft SQL Server\90\Samples\, under the Reporting Services folder. Make notice of this path during installation process...
by mperillo on Aug 8, 2008 at 8:55 PM
You run the msi package and then .... ... you don't event know WHAT copied and WHERE!!! Why there is no document or advise??????????
by raffaeler on Aug 6, 2008 at 6:27 PM