Error while altering a table - maximum row size exceeds

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Error while altering a table - maximum row...

Error while altering a table - maximum row size exceeds

Rate Topic

Display Mode

Topic Options

Author

Message

hemakrmmc

Posted Monday, October 13, 2008 5:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 4:03 AM
Points: 4, Visits: 11

Hi,

I am trying to delete one column from my table using ALTER statement and the following is the SQL statement.

alter table scTabForm0 drop column DataCaptureAutoTaggingXML

But i got the following error

Warning: The table 'scTabForm0' has been created but its maximum row size (18248)
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.

Please help me out from this bug.

Thanks in advance.

Regards,
Hema,

Post #584789

vyas

Posted Monday, October 13, 2008 5:22 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

Check the following link

http://www.sqlservercentral.com/Forums/Topic212912-169-1.aspx

Post #584797

hemakrmmc

Posted Monday, October 13, 2008 5:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 4:03 AM
Points: 4, Visits: 11

I checked the above link and tried this

Select SUM(C.Length) as Length from dbo.SysColumns C where C.id = object_id('ScTabForm0')

I got the grid values as - 17876.

Please justify the case and explain me the solution.

Many thanks
Hema

Post #584802

Kishore.P

Posted Monday, October 13, 2008 5:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, November 26, 2012 3:25 AM
Points: 1,389, Visits: 596

run the following DBCC commands:

DBCC CHECKDB
DBCC CHECKTABLE
DBCC CHECKCATALOG
DBCC UPDATEUSAGE

try it, may solve your problem.

Post #584807

hemakrmmc

Posted Monday, October 13, 2008 5:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 4:03 AM
Points: 4, Visits: 11

Hi,

As of now its not working in my server and i don't know how far it is help full to my case.please explain me a bit more.

Thanks,
Hema

Post #584813

hemakrmmc

Posted Monday, October 13, 2008 11:45 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 14, 2008 4:03 AM
Points: 4, Visits: 11

It will be helpful for me if any body finds the solution.

Thanks
Hema

Post #585210

Michal Mokros

Posted Wednesday, October 15, 2008 5:27 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:47 PM
Points: 2,077, Visits: 415

It is only warning. Your table has so many columns (or so big columns) that it si possible you will not be able to store all data by INSERT statement. You can accept this possible danger if you are sure that your INSERT statements never exceed this limitation but can you really? You can avoid this warning by redesign the table. Row size check is done with column definition changes and that is why you have seen this warning when deleting column too. That means you already had this situation before trying to delete column.

Post #586094

GilaMonster

Posted Wednesday, October 15, 2008 8:37 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 37,738, Visits: 30,009

hemakrmmc (10/13/2008)

Please help me out from this bug.

It's not a bug. It's a warning that your table's too wide. The max size of a row in SQL server is 8060 bytes. Your table has a maximum possible row size of much larger. If you try to insert a row that's bigger than 8060 bytes, the insert will fail.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #586269

Ian C0ckcroft

Posted Thursday, October 11, 2012 12:13 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:23 AM
Points: 842, Visits: 741

run
DBCC CLEANTABLE (0,[table])

Ian Cockcroft
MCITP BI Specialist

Post #1371225

« Prev Topic | Next Topic »

Permissions