Wednesday, 20 February 2008

SQL Server 2000 Maximum Limit

Maximum Database Size : 1,048,516 TB3
Maximum File Size (mdf) : 32TB
Maximum File Size (ldf) : 32TB
Maximum Files per database : 32767
Maximum File Group per database : 256
Maximum Record Size : 8060 Bytes
Maximum Column per Table : 1024
Maximum Column per Primary Key : 16
Maximum Column per Secondary Key : 16
Maximum Column per SELECT statement : 4096
Maximum Column per INSERT statement : 1024
Maximum Tables per SELECT statement : 256
Maximum Rows per Table : Limited by available storage

No comments: