CODEWITHSUNDEEP
sqlsql-server-2008version
user29964
user29964

Reputation: 15990

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.

Upvotes: 1

Views: 2305

Answers (2)

gbn
gbn

Reputation: 432631

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

Upvotes: 5

drew
drew

Reputation: 1312

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.

Upvotes: 0

Related Questions