SQL Server Performance

Maximum Field

Discussion in 'General DBA Questions' started by fauzanf, Jun 30, 2009.

  1. fauzanf New Member

    Dear My Friends,
    I have a question...
    How many field in table can be inserted?
    I using Microsoft SQL Server 2000
    Thanks & Regards,
  2. Madhivanan Moderator

    Read about Maximum capacity specifications in sql server help file
  3. FrankKalis Moderator

    To add to Madhivanan: This limit is rather theoretical. If you come anywhere it, I would think there is a serious problem with your database design.
    Anyway, if I remember correctly, SQL Server 2000 can have as many as 1.024 columns per base table.

Share This Page