Feb
27

Do I have SQL Server 2008 or SQL Server 2008 R2 installed?

By Ben // MS SQL Server 2008, MS SQL Server 2008 R2, SQL // No Comments

How to identify your SQL Server version and edition

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

SQL Server 2008 R2 is a minor upgrade of SQL Server 2008. This means that it shares the same major version number with SQL Server 2008, and has an increment to the minor version. The product version for SQL Server 2008 R2 is 10.50.bbbb.rr. Compare this with the product version for SQL Server 2008 which is 10.0.bbbb.rr.

Tags: SQL

Author: Ben March

Ben March has written 22 articles for us.

@benmarch

RT @MOJOmn: What Does A VC Mean When He Says Your Product Is “A Feature And Not A Company”? http://t.co/L6xxaiZW - you'll get no $ 2012/02/18
RT @pclindeman: Interesting Read: How Companies Learn Your Secrets: http://t.co/YZ7x47VO 2012/02/17
Had a great first day at http://t.co/dKlmltdx. Looking forward to tomorrow! 2012/02/14
@BizDevTalk I'm at buyfun.com in North Mankato. 2012/02/14
@coreybuzzell Yep, first day. It was great. I think it was a good move. 2012/02/14

Do I have SQL Server 2008 or SQL Server 2008 R2 installed?

Author: Ben March

Leave a comment

Blogroll

@benmarch

Tag Cloud!

Knowledge Bomb