SQL Server 2000 Limits

Keep the following things in mind while working with SQL Server 2000.

Features
column name length -> 128
index name length -> 128
table name length -> 128
max indexes per table -> 250
index length -> 900
max index column length -> 900
columns per index -> 16
max char() size -> 8000
max varchar() size -> 8000
max blob size -> 2147483647
max number of columns in GROUP BY Limited only by number of bytes (8060)
max number of columns in ORDER BY Limited only by number of bytes (8060)
tables per SELECT statement -> 256
max columns per table -> 1024
max table row length -> 8036
longest SQL statement -> 16777216
constant string size in SELECT -> 16777207

Posted in Microsoft Technology Tagged with:

Ads