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 - 2002-07-10 : 09:15:08
|
| Ganesh kumar writes "1. I can set a particular field in a table of type varchar with 8000 characters length. But having other fields in the same table with varchar of say 4000 lengths gives a warning saying the maximum row size is execeeded and so the data might be truncated. How to avoid this problem?2. How can i use text or ntext type so that i can have a memo field like situtation. If i use text type then i cannot declare that type in the stored proc and so manipulating it is not possible. Also whenever i use 'select field name...' of that text type field then it is only showing 256 characters." |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-07-10 : 09:21:14
|
| Your last problem is because your default setting in QA buffer starts with 256 chars. Try increasing this, although you will have to do that each time you fire QA.Menu:[Query/CurrentConnectionOptions/Advanced]Daniel Small MIAPwww.danielsmall.com IT Factoring |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-07-10 : 09:25:40
|
| 1. i think the row size maximum is something like 8064 ish. If you genuinely need fields of this size you might be wise to house them in a table of their own.Paul |
|
|
|
|
|
|
Maximum Row size is exceeded