Microsoft Access 2010 Bible

Appendix A: Access 2010 Specifications

1251

SQL Server Database Engine Object Maximum Size or Number for SQL Server 2008 Express

Database size 4GB

Databases per instance of SQL Server 32,767

File groups per database 32,767

Files per database 32,767

File size (data) 4GB (not including log file size)

File size (log) 2TB

Foreign key table references per table 253

Identifier length (in characters) 128

Instances per computer 16

Length of a string containing SQL statements (batch

size)

65,536 × network packet size

Locks per connection Maximum locks per server

Locks per instance of SQL Server Up to 2,147,483,647

Nested stored procedure levels 32

Nested subqueries 32

Nested trigger levels 32

Non-clustered indexes per table 999

Parameters per stored procedure 2,100

Parameters per user-defined function 2,100

REFERENCES per table 253

Rows per table Limited by available storage

Tables per database Limited by number of objects in a database

Partitions per partitioned table or index 1,000

Statistics on nonindexed columns 30,000

Tables per SELECT statement^256

Triggers per table Limited by number of objects in a database

User connections 32,767

XML indexes 249

49_475348-bapp01.indd 125149_475348-bapp01.indd 1251 4/1/10 2:01 PM4/1/10 2:01 PM