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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-31 : 08:54:26
|
| Nalini writes "Hi All, How to handle the sql server errors in ASP or how to avoid the errors in sql server itself only.Even i set the ansi_warnings and ansi_nulls to off,iam getting the following warning..... Warning: The table 'processed_olap_data_1' has been created but its maximum row size (3873071) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.Can u clear me on this issue....Thanks,Nalini." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-31 : 08:58:11
|
| Well, the error message is pretty clear. You should post your table structure (CREATE TABLE statement that defines the table) so we can see specifics, but the reason you're getting this error is because you defined a lot of large columns (multiple varchar(8000) for example) that could possibly allow data to exceed the 8060 byte limit of a SQL Server row. It's a question of either too many columns, or columns that are too big. Unless you change the structure of the table you'll continue to see this message.Is there any particular reason you're using ASP to create tables? |
 |
|
|
|
|
|
Handling errors....