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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-06-07 : 13:35:24
|
| GurusI am getting this error when i am running the script to create a table"WebExceptions' has been created but its maximum row size (8063) 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 byte"I have one column whose datatype is nvarchar whose length is 4000.Is this the problem?Please adviceNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-07 : 13:48:33
|
| It is a problem if you have other columns in the table. Make sure that the max size of the row is 8000 or under. If you are over, then you may encounter a failure if ever someone fills up that column plus adds data to other columns. To avoid this issue, you can use ntext data type for this column instead of nvarchar. There are issues with text, but it might solve your problem.nvarchar(4000) is 8000 bytes since the n data types are double bytes.Tara Kizeraka tduggan |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-07 : 14:33:26
|
| Thanks tara |
|
|
|
|
|
|
Error in creating table