SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterward. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. Let us learn how to install NorthWind Database – samples databases.
After installing sample databases the second most asked question is WHERE IS NORTHWIND?
Northwind database was the best sample database for SQL Server 2000. Since I started to work with AdventureWorks of SQL Server 2005, I like AdventureWorks as much as Northwind. Northwind is not the best database due to few new features of analysis and reporting service of SQL Server 2005. MSDN Book On Line (BOL) uses the AdventureWorks in all of their examples and it makes it easy to follow up if a proper understanding of AdventureWorks schema is developed. However, SQL Server Compact Edition uses Northwind as a sample database.
If you still want to download and install Northwind and Pubs in SQL Server 2005, download them from here.
My recommendation: Start getting familiar with AdventureWorks.
UPDATE: SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 explains how to restored NorthWind to SQL Server 2000 using images.
Reference : Pinal Dave (https://blog.sqlauthority.com)
70 Comments. Leave new
great Job.
Thanks,
Ravi.
gud day sir…
i’m just a newbies regarding a sql server 2008..can you help me to find a site where i can download simple exercises on it..
thank you
A good way is to read questions asked in the forums
sir sql server 2008 already installed and i already create a sample database on it and create a table.but once i close it and open it again an error is occured here’s the error:
Cannot connect to ST-AADO87B6E61E
Additional inforamation:
Login failde for user ‘ST-AADO87B6E61E\student’
(Microsoft SQL Server, ERROR:18456)
Thank sir
‘
I am new in SQL Server 2005, I have installed SQL SErver 2005 standard edition in my PC and it is working fine but its not working in my Laptop
I have WIN 7 installed in my Laptop
Please help and respond
I realize I am not your intended audience. I am an aspiring programmer. I should point out that the introductory video for C# 2005 Express uses the Northwind sample. Obvioulsy and oversight on MS’s part, but may explain people like me looking for the download. Thanks for the blog.
i was workin in SQL server 2000 with northwin database ,
during my exercise i made changes to the data ..
i would like to undo what i`ve done .. who do i ???
Great post, but I have 1 question. Where can I find the bigpubs2005 database>
Thanx
I want to assign an insert task to Job, how can i write job in SQL server to insert.
Thanks for the info!
Hi,
Now it moves to the other site of microsoft, find below the links for details:
https://archive.codeplex.com/
Thanks and Regards
Rajib
Dear Panel…
can u please explain..how to assign JOBs in Server 2005
Regards
Dharmendra
Urgent need help from anybody reg.SSIS Packages on 64 bit
We are currently facing the problem with building 64 Bit SSIS pacakages(located on DB Server..which is 2003 Server Edition, 64 Bit) with connecting 32 bit oracle(loaded on the App Server..Windows 2003, 32 bit) in Business Intelligent Development Studio(Integration Services) with Sql Server 2005 64 Bit. We have installed 64 bit Oracle client and network tools and drivers on Database Server(DB Server), but we are still unable to connect from to Oracle from the BIDS for making the 64 bit SSIS packages.
Please give guide me towards the steps for testing SSIS packages which are in 64 bit Using XML files?
how to proceed towards making these packages??
Thanks
Hello,
I have recently installed Microsoft SQL Server 2005 and running MS SQL server Management Studio version 9. Some reason “AdventureWorks” default/sample database is not there. Could you please give me a direction to download the sample database and which file do I need to use? Once I downloaded, what’s SQL command to run in command window.
Thanks,
why not just tell us where to get the data sample for 2005
Thanks for ur information.
Regards
John
plz send, how to insert multiple rows in a table in sql server2005
Hello
I need a sample database of SQL Server 2005 (prefered AdentureWorks), please send it to my eMail if it is posible.
thank you.
I am unable to attach Adventure works databases. I am getting an error to check DBCC check index. What might be the probable causes to get such error.
thanks,
i need ms sql server 2000 soft ware,which i can use for my practise at home to understand how it works better.i will greatly please if you can asist me on how to get a free download setup.thanks you are doing a great job.
wilson.
@Wilson,
SQL Server has different Editions,
1. Enterprise Edition – All features, very costly
2. Standard Edition – Almost all features, less costly
3. developer edition – All features ( FREE SQL Server 2000) , (~ $50 For SQL Server 2005).
4. Express Edition – very limited features. FREE.
and few other editions…..
So you might want to download, either SQL Server 2000 Developer edition or SQL Server 2005 Express edition , both are free, google it and you will find links.
Hope this helps.
Thanks
Imran.
Hi.
you’re great man.thanks a lot.
Bahman
thanks
I have a question, what is northwind and where is it from?is that a data base from a leisure centre? I really appreciate if you help me and email me the answer.
best regards,
Bahman
i am using sql server 2005 express edition…
i dont have adventureworks db.
how can i get this database.?
thanks..
regards
mohan