I need to alter some columns from nText to Nvarchar(max) on a active database with a simple query like
ALTER TABLE [dbo].[Table] ALTER COLUMN [Column] nvarchar(max);
But my question is, would this be safe to do on database in production? The tables differs from 50 rows to 2m rows. And to answer that question, I think my question should be:
What is the SQL-server doing under the hood when you change a Ntext datatype column to a Nvarchar(max)?
I have tried to find reading material on this, but without any luck.