SQL 2008 R2 Edition Upgrade didn't work

During the upgrade, did you select the existing instance versus creating a new one?

>>Ran the edition upgrade from the DVD, and said it ran successfully. But it didn't! When I check the version, it is still RTM.<<
What upgrade?  
Where did you download the SQL Server 2008 R2 Standard from?
Why did you expect the Product Level would change?

>> Ran the edition upgrade from the DVD, and said it ran successfully. But it didn't! When I check the version, it is still RTM.

Run this script in SSMS:

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

As per your statement, upgrade was successful and hence the edition should state as 'Standard Edition' now else it would show your earlier one..

And the productlevel would be still RTM since you haven't applied any Service packs. Value will change from RTM to SP1 or SP2 when you apply those ( Since SQL Server 2008 R2 doesn't have any Service Packs available, it will show RTM only)

@Arnold - it only gave me a choice of one instance.

@rregan18 - the results are
RTM      Standard Edition (64-bit)

But wouldn't this have returned the same results before the upgrade? What would be different if it was still the eval version?

What are the version numbers ?  This is how you'll see the difference.
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
select @@version

Is it 10.50.1600.x (SQL 2008 R2) versus the older version which was 10.0.1600.Y (SQL 2008)?

Version is 10.50.1600.1.
But it would have been that version anyway?

NO, 10.5.1600.1 is the sql server 2008 R2 version.
The sql server 2008 version is 10.0.1600 note the second number in the major version number.
SQL 2008 10.0 original 10.50 R2

Anyway, how do I know that this isn't the eval version of 10.50.1600.1?

An express version says that it is an express version when you run select @@version
What do you mean eval, are you talking about a version that is the 6-120 trial version?
I'm do not think it will be distinguishable based on the version, It would likely be referenced in the properties of the database server within Sql Server Management Studio, but since I have not check whether there is such an indicator before, can't say for sure.

And if you are still having difficulty deciding what you really have than use something like this (it may make it a tad clearer):

SELECT	CASE SERVERPROPERTY('Edition')
		WHEN 'Enterprise Evaluation Edition' THEN 'I have the Evaluation Edition'
		ELSE 'I no longer have the Evualuation edition, instead I have the: ' + CAST(SERVERPROPERTY('Edition') AS varchar(50))
	END,
	SERVERPROPERTY('ProductLevel')

Select allOpen in new window

Thanks guys. I got a bit confused, mistakenly thinking RTM indicated it was still on the eval version.