Solved

Which MSSQL version (flavour) is installed in the server

Posted on 2012-03-16
3
483 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

747 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

10 Experts available now in Live!

Get 1:1 Help Now