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 |
|
aemciv
Starting Member
4 Posts |
 Posted - 2007-02-06 : 16:37:28
|
| I entered the max 8000 varchar in a column and it will not let me enter more than about 1000. What is the deal?thanksMatt |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-06 : 16:40:20
|
| Is this in Enterprise Manager? or something else?Kristen |
 |
|
|
aemciv
Starting Member
4 Posts |
Posted - 2007-02-06 : 16:41:29
|
| yes it is.thanksMatt |
|
|
|
aemciv
Starting Member
4 Posts |
Posted - 2007-02-06 : 16:42:01
|
| enterprise manager that is. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-06 : 16:48:57
|
| I'm pretty sure that E.M. has a relatively small limit for in-situ editing of data in its Grids.Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-06 : 17:00:37
|
| Yep. Use Query Analyzer instead.Tara Kizer |
|
|
|
aemciv
Starting Member
4 Posts |
Posted - 2007-02-06 : 17:47:09
|
| OK I tried to insert it via Coldfusion/SQL Insert statement, which is ideally how I want to do it, and I got an error saying that the data would be truncated. What does that mean. I know I am a newbee.thanks Matt |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-06 : 18:02:35
|
| I've never used Coldfusion before. I'd suggest trying it from Query Analyzer first though.Tara Kizer |
|
|
|
PoojaJ
Starting Member
10 Posts |
Posted - 2007-02-07 : 04:00:09
|
| The Cumulative Length of all the columns in a Table shold not be more than 8060. So just check that the insert statement does not let the total lenght to exceed this. |
|
|
|
|
|
|
Not allowed column length.