>I have tested on my own test database that when I change a column type from Text to Varchar(max) the content of the column is not lost. But since I am going to do this change on a bunch of customers' databases, is there any chance that the content would be lost?
>I am changing the type in the SSMS.
I also started to do that. This is required for up to date support and it is not clear for how long this old type will be supported.
It has been recommended for a while to use VarChar(Max). I have used it on new fields for a few years now.
So far, the fields which have been changed have continued to work as expected.