how to detect the product level,product version and edition in sql server 2008

 Posted by aswinialuri-19361 on 7/16/2013 | Category: Sql Server Interview questions | Views: 3007 | Points: 40

select serverproperty('product level')
select serverproperty('productversion')
select serverproperty('edition')
By using three queries you can get the product level,product version and edition

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Bandi on: 8/12/2013 | Points: 10
Alternate solution for the above question by using single global variable of SQL Server is as follows:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

Bold part is Product level
Underlined part is Product version
Hyperlinked part is edition
Posted by: Chvrsri on: 8/12/2013 | Points: 10
Hi Bandi,

Appreciate your efforts. We request post the same as a new question in the Interview section so that more people will be able to work on it. This section is only meant to provide the response for the author.

All the alternatives can be posted as a new questions. This will help us to maintain the stability through out the website.

Thank you for your co-operation !!!

Login to post response