Can you tell me which SQL server edition and version is 9.00.1399.00?

Question

My management studo shows 9.00.1399.00. Can any one of you tell me which edition of SQL server is this?

Answer 1

It is probably the RTM version of SQL Server 2005, released to manufacturing, which means that no service packs are applied.

HTH
Thomas Ivarsson

Answer 2

Thanks Thomas.RTM means it is enterprise Edition,right?..Could you please tell me where can we get the Installtion and Configutration guide for Enterprise-RTM edition?...Thanks in advance..

Answer 3

RTM means that it is the first version released to market after a beta or CTP program. It has nothing to do with the enterprise version.

HTH
Thomas Ivarsson

Answer 4

I think Thomas is right that 1399 is the RTM (ie. no services packs) version.

In order to get the Edition of SSAS (standard, enterprise or developer) you could either run the following Powershell script (you may have to change the server name to something other than localhost if you are not on the server console)

  [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") > $null
  $svr = new-object([Microsoft.AnalysisServices.Server])
  $svr.Connect("localhost")
  $svr.Edition

or you could run the following XMLA from Management Studio (then just search for the word "Edition" in the resultset). You may have to tidy up the XMLA - the forum makes a bit of a mess of the formatting

<

 

Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

<

RequestType>DISCOVER_XML_METADATA</RequestType>

<

Restrictions>

<

RestrictionList>

<

ObjectExpansion>ObjectProperties</ObjectExpansion>

</

RestrictionList>

</

Restrictions>

<

Properties>

<

PropertyList>

</

PropertyList>

</

Properties>

</

Discover>

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 5

Also you can query "Select @@Version" to check the edition.

Thanks,

Thameem

Answer 6

Also you can query "Select @@Version" to check the edition.

Thanks,

Thameem

That only shows you the version for the relational engine and you may not always have that installed on the same machine as SSAS.

However another method is to right click on the server in Object Explorer in Management Studio and choose Reports - Standard Reports - General

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 7

Hi ,
Please check with this link
http://www.sqlservercentral.com/articles/Administration/2960/

it says its RTM with NO SP
regards
BornSQL