Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bransom

    Maximum amount of columns per table

    strangely enough, the issue seems to be the Design Table function in Enterprise Manager. It's Win NT running SQL Server 2000, with MMC 1.2. Seems you can only add 300 columns with this thing, otherwise I've been able to add as many as I want (so far) with a simple script.
  2. bransom

    Maximum amount of columns per table

    Hate to bother you for this, but do you possibly have a link for normalizing one's DB?
  3. bransom

    Maximum amount of columns per table

    That's the strange thing. There is no error. Enterprise Manager simply does not allow you to enter any more columns. Would a limitation on an individual record size (of which there has been no indication) prevent the addition of a new column? Hmmm, come to think of it - maybe that's it...
  4. bransom

    Maximum amount of columns per table

    As I understand it, the max amount of columns for any given table in MS SQL 2000 is 1024. I can find no documentation on how this might be set to a different amount for a specific table. I really wish I could though, because I encounter the following problem for a relatively small table: No...

Part and Inventory Search

Back
Top