There's a limit of 8,060 bytes per row in SQL Server 7.0 and 2000. See Maximum Capacity Specifications in BOL.
>Hi everybody,
>
>Today, I tried to create a table and I got this message:
>
>"The total row size (8618) for table 'Table1' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added."
>
>Can I change the maximum number of bytes per row or it's a limitation of SQL Server 7.0 ?
>
>P.S. It's weird because yesterday I ran the same script and I didn't get this message.
>
--sb--