| TABLE 1: Comparison of Jet, MSDE, and SQL Server | ||||
| Features | Jet | MSDE | Desktop SQL Server | SQL Server (and Enterprise version) |
| Operating systems | 9x/NT/2000 | 9x/NT/2000 | 9x/NT/2000 | NT/2000 |
| Maximum database size | 2GB | 2GB | terabytes | terabytes |
| Maximum number of processors | 1 | 2 | 2 | 4 or 32* |
| Upgrade to server or enterprise version of SQL Server | Upsizing Wizard with manual verification | Attach database to SQL Server | Attach database to SQL Server or enterprise version of SQL Server | Already server or enterprise version |
| Integrated Windows NT/2000 security | No | Yes | Yes | Yes |
| Available with Office 2000 or Visual Studio 6.0 | Yes | Yes | No | No |
| Client Access License required? | No | No | Yes | Yes |
| *4 for SQL Server and 32 for Enterprise SQL Server | ||||