How to know if SQL 2008 is R2? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

How to know if SQL 2008 is R2?

Author

Topic

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2010-11-04 : 09:59:51

Hi All,

I need to know if the SQL Server 2008 is R2 or not? How to findout this information? Please suggest.

Thanks,

Zee

patshaw
Posting Yak Master

177 Posts

Posted - 2010-11-04 : 10:13:46

[code]select @@version[/code]

If the instance is R2 it will return 'Microsoft SQL Server 2008 R2....', if not it will just return ''Microsoft SQL Server 2008.....'

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-11-04 : 10:25:54

The version number for R2 is 10.50.xxxx.yy, for 2008 it's 10.00.xxxx.yy. You can also get the version number with:

select serverproperty('ProductVersion')

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2010-11-04 : 10:30:42

This is what I get when I run select @@version

select @@version
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

This is what I get when I run select serverproperty('ProductVersion')

select serverproperty('ProductVersion')
10.0.1600.22

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2010-11-04 : 10:31:39

So is it correct to say that this SQL Server 2008 is not R2? Please confirm.

Thanks.

patshaw
Posting Yak Master

177 Posts

Posted - 2010-11-04 : 10:44:08

Yes. It is not R2.

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2010-11-04 : 10:54:48

Thanks patshaw for the confirmation. I would also like to know what Service Pack has installed for this SQL Server 2008.
When I run SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') I got the following.

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

10.0.1600.22 RTM Standard Edition (64-bit)

Does it tell about which service pack is inatalled?

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2010-11-04 : 11:27:49

Thank you all for your help.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-11-04 : 13:26:15

RTM = no service packs.

--
Gail Shaw
SQL Server MVP

pow1983
Starting Member

3 Posts

Posted - 2010-11-04 : 18:26:42

Hopefully Microsoft will update the following KB soon, but its quite handy at times:
http://support.microsoft.com/kb/321185

---
Rich

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources