Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2011-02-08 : 03:56:08
|
| I recently moved a database to sql 2008is there any disadvantage of switching my ntext fields to a nvarchar(max) field?can i lose any data?will this make the database larger or smaller? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-02-08 : 04:15:57
|
No, you cannot lose data.However, your scripts may break if they are using UPDATETEXT keyword, because NTEXT columns are manipulated in an awful wayand NVARCHAR(MAX) you can treat just like any other NVARCHAR column and UPDATETEXT doesn't work against NVARCHAR(MAX).
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
changing ntext to nvarchar(max)