Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Custom Error to handle table row size error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-14 : 10:08:36
Tonya in S. Florida writes "I have a table with 22 fields. Two fields are of varying length.
The max row size is 8060 bytes. Sometimes, when a row is being written to the DB, the user receives a row size error which is very non-descript. How can I provide a custom error to handle this situation. I do not want to limit the size of each field but provide flexibility depending
on the data input into the two varying fields which are defined as varchar.

Thanks for your help. I'm using SQL Server 7.0."
   

- Advertisement -