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 |
|
rajantonyv
Starting Member
12 Posts |
 Posted - 2002-04-02 : 09:32:42
|
| Hi,We have been trying to identify our SQL server edition for the past couple of days and I am totally confused. According to the person that had installed SQL Server on our servers, he is pretty sure he installed the enterprise version. But if we were to run @@VERSION; look at the SQL Server Error Logs from the MSSQL7/Log subdirectory; right click on the server icon, then "properties"; looked at the SQL Setup log in C:\winnt subdirectory; run sqldiag or xp_trace_setqueryhistory; they all say it is SQL Server Desktop Edition.Example:ERRORLOGMicrosoft SQL Server 7.00 - 7.00.961 (Intel X86) Desktop Edition on Windows NT 4.0 (Build 1381: Service Pack 6)SQLSTUP.LOG14:25:20 System: Windows NT Server14:25:20 SQL Server ProductType: Desktop Edition [0x2]To confuse the issue even more, there is OLAP services installed on the server. Now I was under the belief that OLAP can only be installed on Enterprise and Standard editions. Also, another thing, when we were go on to my co-workers machine it says it is Standard edition. But if I was to look at the server itself properties, it says it is Desktop edition.So in short, I am confused. Is there any true way of identifying what edition we have? Thanks for any help,Raj Antony VRajesh Antony Vattakunnel |
|
|
Jay99
468 Posts |
Posted - 2002-04-02 : 09:42:04
|
| This should help clarify the differences between the Enterprise/Standard/Desktop.Jay<O> |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-03 : 01:52:59
|
| You have Desktop.If you had EE it would say so on @@Version and in the errorlog.You can install OLAP with Desktop.Do you have NT4.0 EE? If not, SQL 7.0 EE cannot be installed.-Chad |
|
|
|
|
|
|
Help!!! SQL Server 7.0 Editions