Solved

Which MSSQL version (flavour) is installed in the server

Posted on 2012-03-16
3
489 Views
Last Modified: 2012-03-19
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,
0
Comment
Question by:Moonatwork
3 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 37730147
you should read http://support.microsoft.com/kb/321185

but in sql

Select @@version
0
 
LVL 38

Expert Comment

by:Adam Brown
ID: 37730268
The native SQL server in R2 is SQL 2008.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 37731662
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now