This limit can't be changed. As a workaround, consider using a second table with a one-to-one relation.
>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.
>
>Thank in advance.
>
>Dave
>Technologies Nter
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com