|| Computer/Processor: Intel® or compatible. Pentium 166 MHz or higher, Pentium PRO, Pentium III, or the minimum processor required for your operating system, which varies for SQL Server editions. Note Microsoft SQL Server 2000 does not have a hardware compatibility list (HCL). If your system meets the minimum requirements listed above, SQL Server 2000 software works on the hardware certified for use with the Microsoft Windows® operating system you are using. For information about the hardware certified for use with your Windows operating system, see the HCL for your version of Windows. The HCL is available online at http://www.microsoft.com/hcl Memory: Enterprise Edition: 64 MB minimum 64 GB Hard Disk: SQL Server 2000, full install: 180 MB SQL Server 2000, typical install: 170 MB SQL Server 2000, minimum install: 65 MB (minimum) SQL Server 2000, client tools only: 90 MB Analysis Services: 50 MB English Query: 12 MB Operating System: Note On Microsoft Windows NT® Server 4.0, Service Pack 5 (SP 5) or later must be installed as a minimum requirement for all SQL Server 2000 editions. Enterprise Edition. Microsoft Windows NT Server 4.0 (Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Standard Server,Windows 2000 Advanced Server, and Windows 2000 Data Center Server). Note: Microsoft Windows 2000 Server is required for some SQL Server 2000 features. Peripherals: SQL Server 2000 Enterprise Edition can be installed on a Windows 2000 Standard box with support for CPU and memory limited to Windows Standard Edition functionality of 4 procs and 4GB. Miscellaneous: To insall Client Tools Only: Windows NT 4.0, Windows 2000 (all versions), and Windows 98. To install Connectivity Only: Windows NT 4.0 or Windows 2000, Windows 98, and Windows 95. Internet Requirements: - Internet software: - Microsoft Internet Explorer 5.0 is required for all installations of Microsoft SQL Server 2000, except for the Connectivity Only option, which requires Microsoft Internet Explorer 4.01 with Service Pack 2. Internet Explorer is required for Microsoft Management Console (MMC) and HTML Help. A minimal install is sufficient, and Internet Explorer does not need to be your default browser. - Internet Information Services: - If you are writing XML applications, see System Requirements for the IIS Virtual Directory Management for SQL Server Utility. - Network Software Requirements: - Microsoft Windows NT, Windows 2000, Windows 98, and Windows 95 have built-in network software. No other network software is required, unless you are using Banyan VINES or AppleTalk ADSP.
|| 32 CPU SMP system support - Requires Windows 2000 DataCenter Server 64 GB RAM support - requires Windows 2000 Data Center Server HTTP access to cubes URL and HTTP access Installation disk imaging Internet standards support Integrated Data Mining Multi-instance support XML Views SELECT (FOR XML) SQL Query Analyzer: Debug stored procedures. Set breakpoints, define watches, view variables and step through code. Trace executing code on server or client. Easily write T-SQL based on templates Cascading referential integrity constraints: Control how changes propagate through tables when keys are updated INSTEAD OF and AFTER triggers: Execute code flexibly by specifying what happens in lieu of an operation or after it User-defined functions: Achieve code reuse by creating T-SQL functions. Incorporate routinely used logic to simplify development VI SAN support: Speed communications between servers with SQL Server 2000 support for direct communication with System Area Network (SAN) devices Improved Features: English Query: Allow all users to access data via natural language queries. Graphically author queries with wizards in the included Visual Studio environment. Generate MDX to query cubes Linked OLAP cubes: Link OLAP cubes on different servers to supercharge analysis. Share with security or sell source cube data over the Internet Security: Help protect data with higher default security on install. Includes support for Secure Sockets Layer (SSL) connections and Kerberos. C2-level certification underway Full-Text Search: Enable Full-Text Search across the Web and intranets for formatted documents (e.g. Word, Excel, and HTML). Track changes automatically Data Transformation Services (DTS): Import and export primary and foreign keys between supported database products. Program the multi-phase data pump and save DTS packages as Visual Basic code Integrated Analysis Services: Build OLAP, data warehousing and data mining solutions to derive value from data Dimensions: Pick the most appropriate dimension type with new parent-child, ragged, changing, write-enabled and dependent dimensions Security in Analysis Services: Lock down sensitive data by defining security for dimensions and cells. Restrict roles to specific combinations of cells Parallel DBCC: Verify database data quickly and efficiently with multi-processor support Failover clustering: Install failover-ready databases directly from Setup. Use active-passive failover with standby hardware or active-active failover in hardware constrained environments. Databases can failover to any surviving node with 4-node failover Highly Scalable and Reliable