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.