Property SQL 2000 SQL 2005
Bytes per GROUP BY, ORDER BY 8,060 8,060
Bytes per index key 900 900
Bytes per foreign key 900 900
Bytes per primary key 900 900
Bytes per row 8,060 8,060
Clustered indexes per table 1 1
Columns per index key 16 16
Columns per foreign key 16 16
Columns per primary key 16 16
Columns per base table 1,024 1,024
Columns per SELECT statement 4,096 4,096
Columns per INSERT statement 1,024 1,024
Database size 1,048,516 TB 524,258 terabytes
Databases per instance of SQL Server 32,767 32,767
Filegroups per database 32,767 32,767
Files per database 32,767 32,767
File size (data) 32 terabytes 16 terabytes
File size (log) 32 terabytes 2 terabytes
Foreign key table references per table 253 253
Nested stored procedure levels 32 32
Nested subqueries 32 32
Nested trigger levels 32 32
Nonclustered indexes per table 249 249
Rows per table Limited by available storage
The sum of the number of all objects in a database cannot exceed 2,147,483,647
