Is SQL Server 2005 Workgroup Edition less robust than SQL Server 2000 Standard Edition?
No, in fact SQL Server 2005 Workgroup Edition offers many additional features beyond SQL Server 2000 Standard Edition. SQL Server 2005 Workgroup Edition provides the key features that small businesses need. It includes the following features that are not present in SQL Server 2000 Standard Edition: Enhanced performance Native XML data type and other new data types Built-in database encryption Common Language Runtime (CLR) integration Backup log shipping for high availability Report Builder, a new end user-reporting tool SQL Server Management Studio, a new management tool Increased memory support to 3 GB For smaller organizations and businesses, SQL Server 2005 Workgroup Edition provides the essential functionality needed in a database solution. SQL Server 2005 Workgroup Edition provides many new features, enhanced performance, and increased memory support, providing more benefits to customers than SQL Server 2000 Standard Edition. Although SQL Server 2000 Standard Edition has some feat
Related Questions
- Can we back up selected tables from a database to a file in SQL Server 2005 standard edition If its possible, what is the command?
- Are applications designed for SQL Server 2000 Standard Edition compatible with SQL 2005 Workgroup Edition?
- What is the difference between SQL Server Workgroup Edition and Standard Edition?