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 |
|
theanh1972
Starting Member
1 Post |
 Posted - 2003-07-16 : 03:51:15
|
| Hi all;In the SQL Server I have made an Image table. It includes 5 fields as -ID[bigint](8), OriginalFineme [nvarchar](255), FileSize [int](4), ContentType[Bynary](8000) and Description [nvarchar](255).I have insert values into Image Table. The result: Insert is failed. ErrorMessage is: "Cannot create a row of size 8085 which is greater than the allowable maximum of 8060.\r\nThe statement has been terminated."Please help me to I fixed it.Thanks;Tien |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-16 : 04:00:47
|
| You're exceeding the maximum storage per table row. Either slim down some of the columns, or split the table horizontally. Are you storing the actual images in your database? If so, why?-------Moo. :) |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-16 : 04:32:52
|
| Yeah... Either store the only paths to images in the table, or use the image datatype, which will allow you to store larger images. |
|
|
|
|
|
|
Cannot create a row of size 8085 which is greater