November 10, 2004 at 8:24 am
With @@version or better : SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
result : Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
Then i compared it with :
Release | Sqlservr.exe |
RTM | 2000.80.194.0 |
SQL Server 2000 SP1 | 2000.80.384.0 |
SQL Server 2000 SP2 | 2000.80.534.0 |
SQL Server 2000 SP3 | 2000.80.760.0 |
But....where can i find the difference between : Enterprise edition (personal edition) and Standard edition (personal edition)
Regards,
Johan
November 10, 2004 at 9:06 am
Is this what you're looking for:
http://www.microsoft.com/sql/evaluation/features/choosing.asp
--
Adam Machanic
whoisactive
November 10, 2004 at 4:58 pm
I don't think there is an Enterprise personal edition and a Standard personal edition. The personal edition distributed with either is the same. According to MS here: http://www.microsoft.com/sql/evaluation/overview/default.asp, personal edition is functionally equivalent to the Standard edition.
Greg
Greg
November 11, 2004 at 1:36 am
Yes, either you have Enterprise Edition or Personal Edition.
Anyway, a quick overview on the differences between each edition you can find in BOL when you look at "Maximum Capacity Specifications".
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 11, 2004 at 1:45 am
Thanks for the information. I think that personal edition is meant to be installed on a local computer (stand-alone) and the standard edition is meant to be installed in a client/server environment. For commercial reasons the two editions are available. The originals are in front of me and they exist. For my job it is neccessary to know which version and edition is used at the customer.
Regards,
Johan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply