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 |
|
everton
Starting Member
4 Posts |
 Posted - 2013-03-18 : 09:21:25
|
| Hello Everyone:I have a table that I need to import data into. In order not to truncate data during the import i have to alter several columns. Once I alter the table the data for a "text" field disappears, even though i did not touch that column. It is the only test field in the table. Any help will be appreciated.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-18 : 13:06:37
|
| hmm...where you trying to alter column type through the ui rather than through the ALTER TABLE t-sql code?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
everton
Starting Member
4 Posts |
Posted - 2013-03-18 : 15:19:14
|
| No UI. Just code. I did nt alter the column type. Just changed the length of several fields, but not the text field in question. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-19 : 01:09:12
|
| nope...my question did you do it through t-sql statements or through UI?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
everton
Starting Member
4 Posts |
Posted - 2013-03-19 : 02:56:40
|
| Sql statement |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-19 : 11:41:20
|
| is the attempt to change identity property of column as well in alter? in any case posting the problematic statement would really help!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Text field dat disappears