text to nvarchar(max) gives warnings, can the results be tru
Cannot alter column [MESSAGE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL to [MESSAGE] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL on table [dbo].[EMAIL_MESSAGE]. The table must be rebuilt. The data in the table will be preserved.
The column [MESSAGE] on table [dbo].[EMAIL_MESSAGE] is being cast from [text] to [nvarchar] (max). There may be loss of precision or data, or the script may fail.
Should I be concerned or just ignore them? The column was altered and the data appears to be okay. How can I be sure the data is okay? I have lots of data in several tables.