Posted by Jens on 06/06/06 18:31

Hi,

SQL Server is limited to 8060 bytes of data stored in row. Depending on
your SQL Server version some data types can be stored in row or outta
row, but for SQL Server if you want to have more than the mentioned
limit you either have to do a 1:1 relation with pulling out some data
to another table, or use data types (But I wouldn´t prefer that as a
solution) that are not stored in row, than stored as pointers (like
text/ntext)

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

• Next in forum: Re: Question on Transaction Log Backups
• Prev in forum: Transactional Replication - Adding New Articles
• Thread view: Re: Record size more than 8060B

[Reply to this message]