2

I believe I have MS SQL Server version 2005, and version 2008 (x64), on my computer. When I connect to localhost in SQL Server Management Studio 2008, the tree on the left says "localhost (SQL Server 9.0.4053)". Also, running:

SELECT SERVERPROPERTY('ProductVersion')

returns 9.00.4053.00.

How do I select 2008 as the version I wish to use?

Improve this question
1
  • 2008 has version 10.0.1600.22
    – MarlonRibunal
    Sep 1, 2010 at 1:05

2 Answers 2

Reset to default
6

Your instances should have names.

By accessing localhost you will get the first instance.

Another intance can be accessed with localhost\INSTANCENAME

Improve this answer
0

To get the instance names you can take a short look in the services list, every instance has a service contanining the instance name. HTH

Improve this answer
2
  • I'd +1, but I don't have enough reputation. Thanks, that helped!
    – Lachlan
    Aug 26, 2010 at 16:22
  • No problem, I'm happy to hear it helped.
    – Paul
    Aug 27, 2010 at 4:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .