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
I 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).
Data lost - convert varchar(max) to varchar(2000)
Posted - 09/12/2009 : 06:47:03
