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.
| Author |
Topic |
|
mashfield
Starting Member
7 Posts |
 Posted - 2006-05-02 : 08:56:37
|
| Hi All,I am using SQLExpress and want to use some of the sample data to educate myself. however, I cannot seem to connect to the Adventureworks databse. I do not even see it within Management Studio Express. I would be grateful for advice or an article that will push in the right direction.Matt A |
|
|
sshelper
Posting Yak Master
216 Posts |
|
|
mashfield
Starting Member
7 Posts |
Posted - 2006-05-02 : 11:47:13
|
| I have installed it. Indeed I have now added (atteched) the database so management studio sees it but when I choose to use it in management studio I just get erors as follows:Msg 208, Level 16, State 1, Line 1Invalid object name 'Production.Product'.when creating a querySELECT * FROM Production.Product |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-05-02 : 14:18:46
|
quote:
Originally posted by mashfield
I have installed it. Indeed I have now added (atteched) the database so management studio sees it but when I choose to use it in management studio I just get erors as follows:Msg 208, Level 16, State 1, Line 1Invalid object name 'Production.Product'.when creating a querySELECT * FROM Production.Product
What happens if you run the following in Mgmt Studio?use AdventureworksgoPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
SQLSever Express & Adventureworks