Locating SQL Server Samples

When trying to get SQL Server samples from codeplex you may wonder where they all go. This is something i keep coming across as it is not something one does often. So here is quick guide to where to find them once installed.

Assuming you installed all the SQL server samples available, you will notice that after installing samples you will have a Start menu shortcut leading to:

C:\Program Files\Microsoft SQL Server\100\Samples

Here you will find the Adventurworks online/offline reports and other SSIS/SSAS samples.

However, if you install the Adventureworks OLTP, DW, and OLAP databases (usually if you are working with B.I.) you need to find the location of some projects in order to deploy. Now you need to look in the Toosl folder i.e.

C:\Program Files\Microsoft SQL Server\100\Tools\Samples

i have assumed a default SQL installation directory on drive C.


One Response to Locating SQL Server Samples

  1. bhavikmerchant says:

    here i am obviously looking at SQL Server 2008 or R2.. which you would glean from the “100” in the directory path

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: