Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-10 : 09:52:42
|
| Rod writes "I am trying to determine whether the Servers I am administering are installed with Standard edition or Enterprise edition of SQL 2000.In the absence of install media, documentation and the original installer, (and the fact I know little about sql 2000) I cannot be sure what version is installed.Is there a simple way to check?It also appears that the same disk was used on two servers. Checking the registry keyhklm/software/microsoft/mssqlserver/mssqlserver/currentversion/serialnumber value is same on both servers.(I am assuming the license does not extent to installing on separate servers that are not clustered)So I really am asking this question so that I know what version to buy for the second server so I can make them legal.Hope you can helpthanks in advance" |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-02-10 : 10:32:35
|
| [code]select serverproperty ('Edition')[/code]That's the simplest way I know of. You can do select @@version, but I sometimes get confused if that displays Windows Enterprise version, or SQL Enterprise version. This spits out only the SQL Server edition type (standard/enterprise). |
 |
|
|
|
|
|
Distinguishing SQL 2000 standard from SQL 2000 enterprise