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 |
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
 Posted - 2007-04-13 : 05:16:39
|
| can anybody tell me what error is this?Cannot sort a row of size 8739, which is greater than the allowable maximum of 8094.thanks in advance,Mahesh |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-13 : 05:24:58
|
| Probably sum of size of all fields in your SELECT query is exceeding allowable size of 8094. Try reducing number of fields in the query. Also what is the datatypes and size of all the columns? Do you really need all of them?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-04-13 : 05:59:43
|
| Read about Maximum Capacity Specifications in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Max Row Size