Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Why does

Author  Topic 

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-07-08 : 07:34:19
The Tutorial that comes with sql server 2005 enterprise edition use the AdventureWorks2008R2 database when this database is only compatable with sql server 2008.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-07-08 : 08:55:41
Which tutorial are you talking about?

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-08 : 09:47:54
http://msftdbprodsamples.codeplex.com/releases/view/45907



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-08 : 09:59:42
A quick search on CodePlex for "Adventureworks 2005" reveals:

http://msftdbprodsamples.codeplex.com/releases/view/4004
Go to Top of Page

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-07-09 : 05:18:47
When i installed it, it came with a folder called "documentation and tutorials". i was just going through that.

Peso and robvolk that is a different database. i already have that.
The AdventureWorks2008R2 has added data, different columns, etc. and it is incompatable with the 2005 edition. it is only for 2008.
But i dont get it because its a 2005 edition tutorial, which came with the 2005 edition disk.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-09 : 08:28:06
You can always script out the database schema and data using 2008 SSMS and run it on a 2005 instance. Assuming they don't use 2008-only features, and if they do you can edit the script (i.e. datetime2 -> datetime)
Go to Top of Page
   

- Advertisement -