Post reply

Is there limit to enter data to the table?

  • August 19, 2008 at 8:46 am

    #123958

    Is there limit to enter data to the table? How many rows can we have in a table and what to do if it reaches the limit? Thank you

  • August 19, 2008 at 8:52 am

    #860057

    jskvirsky (8/19/2008)

    Is there limit to enter data to the table? How many rows can we have in a table and what to do if it reaches the limit? Thank you

    No limits, assuming you do not create ones yourself (a primary key or unique index on a data type that can not store enough different unique values). There are some limits on column number, and row sizes. Since you seem to be using SQL Server 2000 (or 7) (this is a 2000/7 forum), make sure that individual rows are below 8060 bytes (not counting text, binary, ntext columns)

    Another limit is disk space, but that can be increased, and added later.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • August 19, 2008 at 8:54 am

    #860058

    I'm not sure why you posted this in the Backups forum, but there is not limit on the number of rows in a table. It's only limited by the amount of storage space available.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply