InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 09:30:24 GMT20http://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxrun DBCC CLEANTABLE (0,[table])Thu, 11 Oct 2012 00:13:05 GMTIan C0ckcrofthttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspx[quote][b]hemakrmmc (10/13/2008)[/b][hr]Please help me out from this bug.[/quote]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.Wed, 15 Oct 2008 08:37:25 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxIt 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.Wed, 15 Oct 2008 05:27:32 GMTMichal Mokroshttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxIt will be helpful for me if any body finds the solution.ThanksHemaMon, 13 Oct 2008 23:45:38 GMThemakrmmchttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxHi,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,HemaMon, 13 Oct 2008 05:45:24 GMThemakrmmchttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxrun the following DBCC commands:DBCC CHECKDBDBCC CHECKTABLEDBCC CHECKCATALOGDBCC UPDATEUSAGEtry it, may solve your problem.Mon, 13 Oct 2008 05:36:47 GMTKishore.Phttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxI checked the above link and tried thisSelect 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 thanksHemaMon, 13 Oct 2008 05:29:52 GMThemakrmmchttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxCheck the following linkhttp://www.sqlservercentral.com/Forums/Topic212912-169-1.aspxMon, 13 Oct 2008 05:22:41 GMTvyashttp://www.sqlservercentral.com/Forums/Topic584789-5-1.aspxHi, I am trying to delete one column from my table using ALTER statement and the following is the SQL statement.[b]alter table scTabForm0 drop column DataCaptureAutoTaggingXML[/b]But i got the following error[b]Warning[/b]: 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,Mon, 13 Oct 2008 05:13:53 GMThemakrmmc