up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
2008 has version 10.0.1600.22 – MarlonRibunal Sep 1 '10 at 1:05
feedback

2 Answers

up vote 5 down vote accepted

Your instances should have names.

By accessing localhost you will get the first instance.

Another intance can be accessed with localhost\INSTANCENAME

link|improve this answer
feedback
up vote 0 down vote

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

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

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.