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 |
|
amodi
Yak Posting Veteran
83 Posts |
 Posted - 2009-09-12 : 06:47:03
|
Hello friends, I converted one column type from varchar(max) to varchar(2000). The column is trimmed and i lost the data which is greater than 2000 characters. Is there a way to get back the data. I don't have backup |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-09-12 : 07:37:49
|
What did you do when SSMS warned you about possible truncation?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
amodi
Yak Posting Veteran
83 Posts |
Posted - 2009-09-12 : 08:18:13
|
| Hello Peso, Actually i am trying to solve the following problem:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132655I asked a friend to take a "back-up" to be on safe-side, but unfortunately she forget to take the "back-up". I was confident about the back-up and didn't read what SSMS warned about possible truncation.Any ways, if its not possible i will put the old back-up file(at least that can save my friends job).Peso would you please check the following link:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132655Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Data lost - convert varchar(max) to varchar(2000)