thank you for the help.
"Tibor Karaszi" wrote:
> From what I've heard and my tests, it is a meta-data only operation, so it shouldn't shuffle any
> data or log anything significant.
>
> --
> Tibor Karaszi, SQL Server MVP
>
http://www.karaszi.com/sqlserver/default.asp >
http://sqlblog.com/blogs/tibor_karaszi >
>
> "rodchar" <rodchar@discussions.microsoft.com> wrote in message
> news:44FED1CA-D1C0-487E-AE9F-C9C9BF59EFB0@microsoft.com...
> > hey all,
> > i have an ntext field that i want to convert to nvarchar(max) are there any
> > caveats?
> >
> > thanks,
> > rodchar