Question

StSingh on Wed, 23 Jul 2014 15:38:19


Hello,

Can somebody please tell from where can i download below database / table scripts with data

http://technet.microsoft.com/en-us/library/ms124551(v=sql.100).aspx

http://technet.microsoft.com/en-us/library/ms124551(v=sql.100).aspx

http://technet.microsoft.com/en-us/library/ms124543(v=sql.100).aspx

I've downloaded the adventure db 2008R2 but cannot find these tables... please help

I'm using sql Server 2008 R2 Express edition


Sponsored



Replies

SQL DBA1 on Wed, 23 Jul 2014 15:45:28


Hi Singh,

There is already one post for this in forums. Please use below link to get answer.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4c01e9a9-2bfa-488b-a378-fc92ed54cbda/cannot-find-dimdate-table-in-adventureworks-db?forum=sqlanalysisservices

Thanks.

StSingh on Wed, 23 Jul 2014 16:07:43


Thanks Swapna but I'm looking for Adventure Works Cycles company sample db

I've also refereed this link but its broken

http://blog.sqlauthority.com/2008/11/23/sql-server-2008-download-and-install-samples-database-adventureworks-2008/

SQL DBA1 on Wed, 23 Jul 2014 16:12:36


http://msftdbprodsamples.codeplex.com/

Try this

SQL DBA1 on Wed, 23 Jul 2014 16:22:56


Use the top one which is marked as Recommended download. I Installed it and it has all tables


Swapna


StSingh on Wed, 23 Jul 2014 16:28:39


Thanks Swapna for the quick response but this doesn't contain the tables that I'm looking for.... :(

For e.g. 

EmployeeDepartmentHistory

Department 

Employee 

Tom Phillips on Wed, 23 Jul 2014 16:32:52


They are in the HumanResources schema in your print screen above.

StSingh on Wed, 23 Jul 2014 19:34:56


Thanks Tom and Swapna