SQL Server 2000 Enterprise 1 Processor License (Unlimited Clients)
Software Main TypeDatabase
Marketing InformationMicrosoft SQL Server 2000 Enterprise Edition is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and data warehousing solutions.
Software Sub TypeDBMS
License DetailsUnlimited Clients
Features32 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