Post reply

Find out instance of SQL

  • January 13, 2011 at 7:06 pm

    #232213

    How do I find out which instance of SQL I am running 2005, 2008 or 2008 R2

  • January 13, 2011 at 7:08 pm

    #1273384

    SELECT @@VERSION

    Thank You,

    Best Regards,

    SQLBuddy

  • January 13, 2011 at 7:26 pm

    #1273387

    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

    #1273392

    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