Professional Web Applications Themes

Maximum Size of a created table - Microsoft SQL / MS SQL Server

Dear Sir or Madam, Refer to the title above, I was encountered the following error message when I was trying to create a huge size of table using SQL Server 2000. (Server: Msg 1701, Level 16, State 2, Line 2 Creation of table 'xtcwt_InvtSAPOview' failed because the row size would be 13436, including internal overhead. This exceeds the maximum allowable table row size, 8060.) Below are few questions that I would like Sir or Madam to give me some green light: 1) Is that there is a maximum size for every creation of a table in SQL Server 2000? 2) ...

  1. #1

    Default Maximum Size of a created table

    Dear Sir or Madam,

    Refer to the title above, I was encountered the following
    error message when I was trying to create a huge size of
    table using SQL Server 2000.

    (Server: Msg 1701, Level 16, State 2, Line 2
    Creation of table 'xtcwt_InvtSAPOview' failed because the
    row size would be 13436, including internal overhead. This
    exceeds the maximum allowable table row size, 8060.)

    Below are few questions that I would like Sir or Madam to
    give me some green light:

    1) Is that there is a maximum size for every creation of a
    table in SQL Server 2000?

    2) Is there any other way to increase the maximum size
    allowable for a created table?

    3) Is there any alternative ways to create a huge size of
    table?

    Thanks!

    Regards,

    Loh MP



    Loh MP Guest

  2. #2

    Default Maximum size of table

    Arun replies:

    To get the maximum size specification, go to SQL server
    books online search in index for
    maximum capacity specifications

    From the error it seems that you have exceeded the maximum
    row size which is 8Kb.

    >-----Original Message-----
    >Dear Sir or Madam,
    >
    >Refer to the title above, I was encountered the following
    >error message when I was trying to create a huge size of
    >table using SQL Server 2000.
    >
    >(Server: Msg 1701, Level 16, State 2, Line 2
    >Creation of table 'xtcwt_InvtSAPOview' failed because the
    >row size would be 13436, including internal overhead.
    This
    >exceeds the maximum allowable table row size, 8060.)
    >
    >Below are few questions that I would like Sir or Madam to
    >give me some green light:
    >
    >1) Is that there is a maximum size for every creation of
    a
    >table in SQL Server 2000?
    >
    >2) Is there any other way to increase the maximum size
    >allowable for a created table?
    >
    >3) Is there any alternative ways to create a huge size of
    >table?
    >
    >Thanks!
    >
    >Regards,
    >
    >Loh MP
    >
    >
    >
    >.
    >
    Arun[Symbiosis] Guest

  3. #3

    Default Re: Maximum Size of a created table

    >>> 1) Is that there is a maximum size for every creation of a
    >>> table in SQL Server 2000?
    By using data types stored 'in row' such as varchar/nvarchar then you are
    limited to the SQL row size of 8060.

    However, instead of using varchar/nvarchar consider using text/ntext
    instead, each column defined text can hold around 2GB of data and you can
    have mulitple text columns in a table.
    >>> 2) Is there any other way to increase the maximum size
    >>> allowable for a created table?
    see 1
    >>> 3) Is there any alternative ways to create a huge size of
    >>> table?
    see 1

    --
    Tony Rogerson
    SQL Server MVP
    [url]http://www.sqlserverfaq.com?mbr=21[/url]
    (Create your own groups, Forum, FAQ's and a ton more)


    Tony Rogerson Guest

  4. #4

    Default Re: Maximum Size of a created table

    the maximum number of bytes allowed in a row in SQL Server 7/2000 is limited
    to 8060.
    If you have many CHAR/VARCHAR with big sizes then you might consider
    replacing them with TEXT data types. TEXT data is stored on separate data
    pages and doesn't affected with 8060 byte limit. However TEXT dataype has
    somme limitations mainly while using string functions, you can not use all
    the string function on TEXT datatype except PATINDEX and SUBSTRING. you can
    not declare variables of type TEXT as well.

    You can also consider breaking the table into two or more tables, with a 1
    to1 relationship between the tables.

    --
    -Vishal
    "Loh MP" <mplohcwt.com.my> wrote in message
    news:07e101c3447b$f8dcec40$a501280aphx.gbl...
    > Dear Sir or Madam,
    >
    > Refer to the title above, I was encountered the following
    > error message when I was trying to create a huge size of
    > table using SQL Server 2000.
    >
    > (Server: Msg 1701, Level 16, State 2, Line 2
    > Creation of table 'xtcwt_InvtSAPOview' failed because the
    > row size would be 13436, including internal overhead. This
    > exceeds the maximum allowable table row size, 8060.)
    >
    > Below are few questions that I would like Sir or Madam to
    > give me some green light:
    >
    > 1) Is that there is a maximum size for every creation of a
    > table in SQL Server 2000?
    >
    > 2) Is there any other way to increase the maximum size
    > allowable for a created table?
    >
    > 3) Is there any alternative ways to create a huge size of
    > table?
    >
    > Thanks!
    >
    > Regards,
    >
    > Loh MP
    >
    >
    >

    Vishal Parkar Guest

Similar Threads

  1. Maximum page size
    By Allan_Mills@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: April 6th, 08:14 AM
  2. maximum size arrays?
    By Sjeiti in forum Macromedia Flash
    Replies: 0
    Last Post: December 9th, 09:56 AM
  3. Replies: 0
    Last Post: August 22nd, 11:04 PM
  4. maximum filesystem size on AIX 4.3.3
    By knokmans in forum AIX
    Replies: 1
    Last Post: July 15th, 09:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139