Microsoft KB Archive/180378

From BetaArchive Wiki

INF: Microsoft Products That Include the SQL Server Product

Q180378



The information in this article applies to:


  • Microsoft SQL Server versions 7.0, 6.5





SUMMARY

This article lists the different products and product packages that include the SQL Server product.



MORE INFORMATION

Source SQL Server version
SQL Server 2000 Enterprise Edition SQL Server Build 8.00.194
SQL Server 2000 Standard Edition SQL Server Build 8.00.194
SQL Server 2000 Personal Edition SQL Server Build 8.00.194
SQL Server 2000 Developer Edition SQL Server Build 8.00.194
SQL Server 2000 Enterprise Evaluation Edition SQL Server Build 8.00.194
SQL Server 2000 Desktop Engine SQL Server Build 8.00.194
SQL Server 7.0 SQL Server Build 7.00.623
SQL Server 7.0 Service Pack 1 SQL Server Build 7.00.699
SQL Server 7.0 Service Pack 2 SQL Server Build 7.00.842
SQL Server 7.0 Service Pack 3 SQL Server Build 7.00.961
SQL Server 6.5 SQL Server Build 6.50.201
SQL Workstation 6.5 (15 connections, 1 user)
SQL Server Enterprise Edition 6.5
SQL Server 6.5 Service Pack 1 SQL Server Build 6.50.213
SQL Server 6.5 Service Pack 2 SQL Server Build 6.50.240
SQL Server 6.5 Service Pack 3 SQL Server Build 6.50.258
SQL Server 6.5 Service Pack 4 SQL Server Build 6.50.281
SQL Server 6.5 Service pack 5 SQL Server Build 6.50.415
SQL Server 6.5 Service pack 5a SQL Server Build 6.50.416
Back Office 2000 Microsoft SQL Server 2000, Standard Edition
Back Office 4.5 Microsoft SQL Server 7.0, Enterprise Edition
Back Office Small Business Server 4.5 Microsoft SQL Server 7.0, Standard Edition
Microsoft Office 2000 MSDE 1.0 - SQL Server 7.0 compatible
Microsoft Office 2002 (XP) SQL Server 2000 Desktop Engine
Small Business Server SQL Server build 6.5.259 w/ limitations
MSDN SQL Server 6.5 and SQL Workstation 6.5
Visual InterDev Studio SQL Server Developer Edition 6.5
http://www.microsoft.com/sql 120-day trial of SQL Server 2000 Enterprise Evaluation Edition
Site Server Enterprise Edition SQL Server 6.5 Service Pack 3
Microsoft Message Queue Server SQL Server 6.5 Service Pack 3
SELECT CD Custom CDs (products are selected)
TechNet Contains service packs only
Back Office 4.0 SQL Server 6.5 Service Pack 3
Visual C++ 5.0 Enterprise Edition SQL Server Developer Edition 6.5
Visual Basic Enterprise Edition SQL Server Developer Edition 6.5


The Microsoft Windows NT 4.0 Option Pack will install an evaluation copy (120-day trial) of SQL Server 6.5 Service Pack 3 only if a Microsoft Message Queue Server (MSMQ) Primary Site Controller (PSC) is installed. In addition, you can run setup from the MSSql directory on the Windows NT 4.0 Option Pack CD to install the evaluation copy manually.

The SQL Server that comes in the MSMQ directory of the Windows NT Server 4.0 Enterprise Edition CD is a modified version of SQL Server 6.5 Service Pack 3. It is a "limited" version, in that it can only be used with Microsoft Message Queue Server (MSMQ). However, if you issue a "select @@version" statement, it shows the same build as the full version of SQL Server 6.5 Service Pack 3.

For additional information about the limitations of SQL Server Small Business Version, please see the following article in the Microsoft Knowledge Base:

Q179856 INF: SQL Small Business: Licensing, Connections, Limitations

Both SQL Workstation and SQL Server Developer Edition are used when referring to the limited user-connection SQL Server package. To determine if SQL Server or Workstation is being used, issue the statement below. The value returned will be 15 for SQL Workstation or SQL Server Developer Edition.

select @@max_connections 

Additional query words: sp sp3

Keywords :
Issue type : kbinfo
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ700 kbSQLServ650


Last Reviewed: June 26, 2001
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.