Which MSSQL version (flavour) is installed in the server

Hi Guys,

I am trying to find out which MSSQL version (flavour) is installed in the server (standard or Ent or Web ) in R2 versions

when I open SQL Management Studio --> Help --> about , its not showing the SQL flavour
I get below list

----------------------------------------------------------------------------------------------------
Microsoft SQL Server Management Studio      10.50.1600.1
Microsoft Data Access Components (MDAC)      6.0.6001.18000
Microsoft MSXML                        3.0 6.0
Microsoft Internet Explorer            8.0.6001.18975
Microsoft .NET Framework            2.0.50727.3615
Operating System                  6.0.6001
----------------------------------------------------------------------------------------------------

what is the easiest way to find out which flavour is installed in the servers

Thank you,
MoonatworkAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
acbrown2010,
The native SQL server in R2 is SQL 2008.
What?

Moonatwork,
>>I am trying to find out which MSSQL version (flavour) is installed in the server (standard or Ent or Web ) in R2 versions<<
This will tell you the SQL Server edition you are using:
SELECT SERVERPROPERTY('Edition')
0
 
James MurrellProduct SpecialistCommented:
you should read http://support.microsoft.com/kb/321185

but in sql

Select @@version
0
 
Adam BrownSr Solutions ArchitectCommented:
The native SQL server in R2 is SQL 2008.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.