Iran Developers Network

Hardware

Requirements

Processor

Pentium 166 MHz or higher

Memory

32 MB RAM (minimum for Desktop Engine),
64 MB RAM (minimum for all other editions),
128 MB RAM or more recommended

Hard disk space

270 MB (full installation),
250 MB (typical),
95 MB (minimum),
Desktop Engine: 44 MB
Analysis Services: 50 MB minimum and 130 MB typical
English Query: 80 MB

Hardware

Requirements

Processor

Pentium 75 MHz or higher

Memory

8 MB of RAM required for Access 2000,
plus 4 MB of RAM for each application running simultaneously,
plus memory for the operation system:

· ۱۶ MB of RAM for Windows 95 or Windows 98

· ۳۲ MB of RAM for Windows Me or Windows NT

· ۶۴ MB of RAM for Windows 2000

· ۱۲۸ MB of RAM for Windows XP

Hard disk space

Access 2000 requires over 30 MB of hard disk space

Operating System

Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Desktop Engine

SQL Server CE

Windows CE

No

No

No

No

No

Yes

Windows 9x

No

No

Yes

No

Yes

No

Windows NT 4.0 Workstation with Service Pack 5

No

No

Yes

Yes

Yes

No

Windows NT 4.0 Server with Service Pack 5

Yes

Yes

Yes

Yes

Yes

No

Windows NT 4.0 Server Enterprise Edition with Service Pack 5

Yes

Yes

Yes

Yes

Yes

No

Windows 2000 Professional

No

No

Yes

Yes

Yes

No

Windows 2000 Server

Yes

Yes

Yes

Yes

Yes

No

Windows 2000 Advanced Server

Yes

Yes

Yes

Yes

Yes

No

Windows 2000 DataCenter

Yes

Yes

Yes

Yes

Yes

No

Windows XP Professional

No

No

Yes

Yes

Yes

No

Licensing Options

SQL Server 2000 Standard Edition

SQL Server 2000 Enterprise Edition

Processor

$4,999 per processor

$19,999 per processor

Server/Per-Seat CAL

with 5 CALs – $1,489
with 10 CALs – $2,249

with 25 CALs – $11,099

Products

New User Price

Upgrade Price

Microsoft Access 2002

$339

$109

Office XP Professional Edition

$579

$329

Office XP Developer Edition

$799

$549

Feature

Access 2000

SQL Server 2000

SMP support

Not Supported

Supported

Tables

Relational tables

Relational tables,
Temporary tables

Triggers

Not Supported

AFTER triggers,
INSTEAD OF triggers

Procedures

Not Supported

Microsoft T-SQL statements

User-defined functions

Not Supported

Scalar functions,
Inline table-valued functions,
Multistatement table-valued functions

Views

Not Supported

Supported

Transaction logging

Not Supported

Supported

Recovery

Recovery to last backup

Recovery to last backup,
recovery to the point of failure,
recovery to a specific point in time

Integration with
Windows NT security

Not Supported

Supported

Feature

SQL Server 2000

Access 2000

database size

1,048,516 TB

2 GB plus linked tables size

objects in a database

2,147,483,647

32,768

user name length

128

20

password length

128

14

table name length

128

64

column name length

128

64

index name length

128

64

Number of concurrent users

limited by available memory

255

columns per table

1024

255

table size

limited by available storage

1 GB

number of indexes in a table

250

32

number of columns in an index

16

10

bytes per row

8060

2000

number of tables in a query

256

32

columns per SELECT statement

4096

255

nested subqueries

32

50

number of enforced relationships

253

32

SQL statement size

65,536 * Network packet size
(4 KB, by default)

approximately 64,000