• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

how to identify if my SQL install is trial or full version

how can I tell if a server is running SQL 2008 R2 trial or full version?

I put the product key in, and it says it did it.  It was suspiciously fast about it so how can one know for sure?
0
calljk
Asked:
calljk
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Run this query in SSMS:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

If it returns Evaluation, then it is trial else it would list the edition like Standard or Developer or Express like that..
0
 
thekeyboardwizardCommented:
Open SQL Management Studio and run this query.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Execute it ...

It will list the version number, service pack and which edition it is.

~~thekeyboardwizard~~
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now