Home Forums SQL Server 7,2000 Administration Error while altering a table - maximum row size exceeds RE: Error while altering a table - maximum row size exceeds

  • 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, MVP, M.Sc (Comp Sci)
    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