Trying to get AdventureWordks to work

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

Trying to get AdventureWordks to work

Author

Topic

walterbyrd
Starting Member

12 Posts

Posted - 2011-06-08 : 12:52:07

My Setup:
- HP G62 laptop with i3 processor and 4GB of RAM
- Windows 7 64-bit
- MS-SQL Server 2008 R2 (Express Editon)

Went to this website:
- http://msftdbprodsamples.codeplex.com/releases/view/55926

Downloaded and installed this file:
- AdventureWorks2008R2_SR1.exe

I ran the exe file, and then opened "Server Management Studio."
The databases seem to exist.

In the "Object Explorer" under "Databases" I can see the following:
- AdventureWorks
- AdventureWorksDW
- AdventureWorksDW2008R2
- AdventureWorksLT
- AdventureWorksLT2008R2

There seems to be colums within the databases.

But when I click "New Query" and enter the following:

USE AdventureWorks;
GO
SELECT * FROM HumanResources.Employee

And then I click that little green arrow, to execute:
I get this "Debugging query..." message, that just seems to hang.
I get no output.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-08 : 12:55:45

You want to click the exclamation point to Execute, not debug. They changed the icon in SQL 2005, green arrow debugs.