February 22, 2008 at 11:00 pm
Just started a new gig
When I run
@@VERSION
or
SELECT SERVERPROPERTY('productversion')
, SERVERPROPERTY ('productlevel')
, SERVERPROPERTY ('edition')
, SERVERPROPERTY ('LicenseType')
both return 2005 Developer Edition, however the Network Admin says it's Enterprise Edition (I know about the features).
Assuming the firm has possibly upgraded from Developer Edition to Enterprise Edition will these server properties change?
February 23, 2008 at 8:57 am
they certainly should change because there are usage restrictions with developer editions (licence).
I haven't performed a dev to EE edition myself.
Maybe it's worth the effort to reinstall if you have doubts (as shown).
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2008 at 10:43 am
I doubt that you've upgraded if it says "Developer"
February 23, 2008 at 11:42 am
Thanks all
February 24, 2008 at 2:08 pm
Hi,
@@VERSION reports the edition to which you have connected.
that means may be your admin is giving you wrong information.
Thanks -- Vj
February 25, 2008 at 4:30 am
The version is read from the "checksum" key in the registry every time sql starts so if it says developer it is.
You can just run the enterprise setup using SKUUPGRADE and it will update it to say enterprise version (you will need to reapply any hotfixes and service packs http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade) - generally (check this out with your licensing people) as long as you have the correct licenses in place you should be fine - if you leave it as developer you won't loose out on any functionality.
Ed
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply