April 4, 2011 at 11:42 am
I have never been able to keep up with what build number belongs to what SP level or suite (Std, Ent or R2). :hehe:
Can someone point me to a table that I can lookup to compare and check to see if the installed instance is regular SQL 2005/8 or R2?
@@VERSION returns the following....
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
Some other folks want to know if this is R2 or not. I installed with an R2 iso but I need more clarification.
Thanks
April 4, 2011 at 11:48 am
Look up SERVERPROPERTY function; that will give u every detail abt your installation
April 4, 2011 at 11:52 am
Like this:
select SERVERPROPERTY('ProductVersion' ) as version
, SERVERPROPERTY('Edition' ) As Edition
, SERVERPROPERTY('EngineEdition') As EngineEdition
, SERVERPROPERTY('MachineName' ) AS MachineName
, SERVERPROPERTY('ProductLevel' ) AS ProductLevel
, SERVERPROPERTY('ServerName' ) AS ServerName
April 4, 2011 at 12:06 pm
Warren Peace (4/4/2011)
I have never been able to keep up with what build number belongs to what SP level or suite (Std, Ent or R2). :hehe:Can someone point me to a table that I can lookup to compare and check to see if the installed instance is regular SQL 2005/8 or R2?
@@VERSION returns the following....
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
Some other folks want to know if this is R2 or not. I installed with an R2 iso but I need more clarification.
Thanks
SQL 2008 R2 is version 10.50.xxxx.
SQLServer Central maintains an R2 build list here[/url].
2008 Build list can be found here[/url].
SQL 2005 Build list can be found here[/url].
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 4, 2011 at 12:24 pm
Thanks everyone!!!
April 4, 2011 at 12:33 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply