January 13, 2011 at 7:06 pm
How do I find out which instance of SQL I am running 2005, 2008 or 2008 R2
January 13, 2011 at 7:08 pm
SELECT @@VERSION
Thank You,
Best Regards,
SQLBuddy
January 13, 2011 at 7:26 pm
What I meant was that if I am using the management studio to connect to multiple databases, how can I find that out from the explorer window.
January 13, 2011 at 7:42 pm
If you look right next to the SQL server name in the object explorer it shows you the version.. You can say that 9.* is SQL 2005, 10.0.* is SQL 2008 R1, 10.5.* is SQL 2008 R2, and right night 11.* is SQL 2010..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply