asked on

Check if SQL 2008 R2 version is RTM

Hi
I want to check if one of our SQL installs is the RTM eval version. How I can check this, and find when the eval is up?
Thanks

SOLUTION

James Murrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Aaron Shilo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jdhackett

ASKER

Thanks.
it came back like this:

Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.50.1600.1 No

SQL Versions
has a list of the different versions, seems this version is indeed SQL Server 2008 R2 RTM.

jdhackett

ASKER

ashilo - our posts must have crossed. That way works as well, better even, as no need for me to look up the version. Thanks!

jdhackett

ASKER

One thing that was not answered - how can I tell when the eval will expire?

SOLUTION

Aaron Shilo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jdhackett

ASKER

Thanks, Solution 0 worked fine.
I've often read that it appears under Help/About, but I've never seen any dates there. I think there is something missing in your post though, so maybe that would make it clearer.

Aaron Shilo

yea missing a screeni
image91.png

jdhackett

ASKER

Interesting, mine looks different. No days mentioned at all.
Either way, Solution 0 works fine, so thanks very much.
SQL.jpg