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 |
|
Goalie35
Yak Posting Veteran
81 Posts |
 Posted - 2010-06-04 : 00:23:45
|
I've been using sql 2005 Developer Edition for a while now however I've recently installed a copy of sql 2008 Enterprise Edition onto my machine.The installation went fine. I now have both sql 05 developer & sql 08 enterprise on my machine, however I tried creating the microsoft "AdventureWorks2008" database in management studio '08 but kept running into issues. So I did a "select @@version" query within my 2008 management studio and I received the following: quote:
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)
So it seems my 2008 management studio is still running sql '05. How can I update this to run sql '08? I could always uninstall sql '05 entirely but I'd prefer to hang onto it for now in case I need it down the road.Thanks. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-06-04 : 00:46:33
|
| When you open SQL Server Management Studio, you have to connect to an instance of SQL Server. When you do that, you are connecting to your 05 instance - not the 08 instance. Just connect to the 08 instance and you'll be fine.Most likely, you are connecting to the default instance instead of the named instance. When you installed 2008 - you had to identify the instance name. To find what the instance name is, open SQL Server 2008 Configuration Manager and see what the instance name is under the 2008 services. |
 |
|
|
|
|
|
Installed sql '08 but stuck running in sql '05??