Choose the right edition of SQL for your dedicated server
 |
There are various different editions of SQL Server 2000 designed to accommodate your individual needs, demands and price requirements. It is appropriate for a broad range of solution types, including e-commerce, data warehousing, and line-of-business applications.
SQL Server 2000 enterprise edition, standard edition, and workgroup edition are the only editions of SQL Server 2000 that can be installed and used in live (deployed) server environments.
So, if you are building a database or analysis application that accesses SQL Server 2000, you must use one of the above editions. Other editions cannot be used in deployed/live (i.e. can only be used in development or in testing) server solutions, because of technical and licensing restrictions.
Click below to read more about each edition to help you choose which is best for your dedicated server:
- Microsoft SQL Server 2000 enterprise edition
- Microsoft SQL Server 2000 standard edition
- Microsoft SQL Server 2000 workgroup edition
| Features | Enterprise Edition | Standard Edition | Workgroup Edition |
| Advanced Analysis Features for OLAP |  |  | |
| Clickstream Analysis | | | |
| Closed-Loop Analysis | | | |
| Comprehensive Analysis Services | | | |
| Data Mining | | | |
| Data Transformation Services | | | |
| Data Warehousing Alliance | | | |
| Distributed Partitioned Views | | | |
| English Query | | | |
| Extend Applications | | | |
| Full-Text Search | | | |
| High Availability | | | |
| Indexed Views | | | |
| Integration with Microsoft Windows Server System-BizTalk and Commerce Server | | | |
| Meta Data Services | | | |
| Office 2000 Integration | | | |
| Online Analytical Processing (OLAP) | | | |
| OLAP Flexibility | | | |
| Replication | | | |
| Rich XML Support | | | |
| Scalability | | | |
| Security | | | |
| Simplified Database Adminstration | | | |
| Virtual Interface System Area Network | | | |
| Web Access to Data | | | |
| Web and Application Hosting | | | |
| Web-Enabled Analysis | | | |
Go Back to main SQL Server page
To discuss your requirements for an SQL Server with your dedicated server solution simply call us now on 0800 4584545, or request a quote.
