Where is the difference between all versions in 1MSSQLSERVER2000? 2 How to choose? 3 How do you know which version is installed? 1. SQL Server 2000: Version and Components SQL Server 2000 version includes Enterprise Edition, Standard Edition, Personal Edition, Development and Evaluation Edition. The following quotes from SQL Server 2000 online help: The available versions of Microsoft® SQL ServerTM 2000 are as follows: SQL Server 2000 Enterprise Edition is used as a production database server. Supports all available features in SQL Server 2000 and can be expanded according to supported the largest Web site and business online transaction (OLTP) and data warehouse systems. SQL Server 2000 Standard Edition is used as a database server for a small working group or department. SQL Server 2000 Personal Edition For mobile users, these users are sometimes disconnected from the network, but the running application requires SQL Server data storage. Use a personal version when running a stand-alone application that requires a local SQL Server data stored on the client computer. SQL Server 2000 Development Edition is used to develop applications that use SQL Server 2000 as data storage. Although the development version supports all functions of the Enterprise Edition, the developers can write and test applications that can use these features, but can only be used as the development and test system, and cannot be used as production servers. The SQL Server 2000 Windows CE version uses the Microsoft® SQL Server 2000TM Windows® CE version (SQL Server CE) on the Windows CE device on the Windows CE device. You can copy data with any versions of SQL Server 2000 so that Windows CE data is synchronized with the primary database. SQL Server 2000 Enterprise Evaluation Edition can be downloaded from the Web for free downloadful version. Used only to evaluate the SQL Server function; the version will stop running after 120 days. In addition to these versions of SQL Server 2000, SQL Server 2000 Desktop Engine components allow applications to develop a replica of the SQL Server 2000 relational database engine with their application. Because the functionality of the database engine in SQL Server 2000 Desktop Engine is similar to the database engine in the SQL Server versions, the size of the Desktop Engine database cannot exceed 2 GB. The SQL Server 2000 desktop version and SQL Server 2000 have a concurrent work load controller that restricts the performance of the database engine when it is derived. For more information on concurrent workload regulators, see the SQL Server 2000 database on your desk. 2, see online help. More detailed view of the online help. 3, a, select @@ version b, select serverproperty ('product "), ServerProperty (' product ') see http://support.microsoft.com/default.aspx?scid=kb; ZH-CN; 321185 Thank you 9CBS CCCP203 (CCCP203)!
