Number of columns allowed in sqlserver 2000

• sweeper_bill

  Ten Centuries

  Points: 1015

  More actions

  May 7, 2003 at 11:06 am

  #80887

  What is the total number of columns allowed in a table in SQLSERVER 2000?

  William H. Hoover

  Louisville, Ky

  sweeper_bill@yahoo.com

  
  William H. Hoover
  Louisville, Ky
  sweeper_bill@yahoo.com

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 7, 2003 at 11:18 am

  #456437

  Columns per table is 1024.

• PBirch

  SSCrazy Eights

  Points: 8493

  More actions

  May 7, 2003 at 11:31 am

  #456439

  Check out the section "Maximum Capacity Specifications" in BOL. That has limitations and capacities for all version of SQL Server 2000.

  Patrick

  Quand on parle du loup, on en voit la queue