How can I see if SQL Server 2008 is the R2 release?

Question says it all.

Is there a way I can see 开发者_高级运维what version of SQL 2008 is installed?

It's either the SQL 2008 enterprise edition or SQL 2008 R2 enterprise.

SELECT @@VERSION

Should be 10.5xxxxx for R2. It is 10.0xxxx for "plain" SQL Server 2008

For edition: SELECT SERVERPROPERTY('Edition'). SERVERPROPERTY gives you quite a lot

When you connect to it using management studio, it shows the server name and version. 2008 is 10.0.1600, 2008 R2 is 10.50.1600.