SQL Server Tables Error

From: calvin (mahendran_easy_at_yahoo.com)
Date: 09/23/04 

Date: Wed, 22 Sep 2004 20:07:03 -0700

When ever I create a table in SQL Query Analyzer, Its creating the table but
giveing me this error msg.

sometime some data are not able to update. is that because of this?
can any one help me?
 

 Warning: The table 'RolesPrivileges' has been created but its maximum row
size (8253) exceeds the maximum number of bytes per row (8060). INSERT or
UPDATE of a row in this table will fail if the resulting row length exceeds
8060 bytes.

you can email to aka_djclan@hotmail.com
                         aka.calvin@gmail.com
                         mahendran_easy@yahoo.com

Urgent

Relevant Pages

  • SQL Server Tables Error
    ... When ever I create a table in SQL Query Analyzer, ... giveing me this error msg. ... UPDATE of a row in this table will fail if the resulting row length exceeds ...
    (microsoft.public.data.odbc)
  • SQL Server Tables Error
    ... When ever I create a table in SQL Query Analyzer, ... giveing me this error msg. ... UPDATE of a row in this table will fail if the resulting row length exceeds ...
    (microsoft.public.data.ado)
  • Re: maximum row size?
    ... This means that you have exceeded the maximum row size in SQL Server. ... Any TEXT data type occupies only the amount of space required to store a ... "Martin Hellat" wrote in message ... table will fail if the resulting row length exceeds 8060 bytes. ...
    (microsoft.public.sqlserver.programming)
  • Table mit maximum row size
    ... beim erstellen einer DB mit einem SQL-Script bekam ich folgende SQL-Meldung ... The table 'customers' has been created but its maximum row size ... row in this table will fail if the resulting row length exceeds 8060 bytes. ...
    (microsoft.public.de.sqlserver)
  • Re: SQL Server Tables Error
    ... Let's take a look at how you have it laid out. ... Bill Vaughn ... The table 'RolesPrivileges' has been created but its maximum row ... > size exceeds the maximum number of bytes per row. ...
    (microsoft.public.data.ado)