dbTalk Databases Forums  

How to find out the edition of SQL Server - Enterprise or Standard running

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to find out the edition of SQL Server - Enterprise or Standard running in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon Lenn
 
Posts: n/a

Default How to find out the edition of SQL Server - Enterprise or Standard running - 06-08-2004 , 04:52 PM






I want to use some of the Enterprise edition features. How can we find
out if the installed server is a enterprise edition or standard
edition please clarify.

Thanks
Simon

Reply With Quote
  #2  
Old   
Francesco De Chirico
 
Posts: n/a

Default Re: How to find out the edition of SQL Server - Enterprise or Standard running - 06-09-2004 , 09:56 AM






Take a look here:

http://msdn.microsoft.com/library/de..._AccessDSO.asp


in the "Getting Information About the Analysis Server" section, you can find
this piece of code:

' Determine the edition of Analysis Services server installed.
Select Case dsoEdition
Case olapEditionUnlimited
.AddItem "Edition: " & "Enterprise Edition"
Case olapEditionNoPartitions
.AddItem "Edition: " & "Standard Edition"
Case Else
.AddItem "Edition: " & " (Unknown Edition)"
End Select

Francesco De Chirico



Reply With Quote
  #3  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: How to find out the edition of SQL Server - Enterprise or Standard running - 06-09-2004 , 10:12 AM



See
http://www.microsoft.com/technet/pro.../anservog.mspx

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> wrote

Quote:
I want to use some of the Enterprise edition features. How can we find
out if the installed server is a enterprise edition or standard
edition please clarify.

Thanks
Simon



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.