• Enterprise manager's just hiding the warnings. The max size for a row is 8060 bytes. You can create the table, but should any insert try and add more than 8060 bytes to the row, the insert will fail.

    If you need that much space, you'll have to use TEXT columns.

    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