nvarchar(n) and nvarchar(max) different datatypes?

Hi bala,

it is not entirely true that index dependent columns can not be changed. The quote from BOL that I gave states as much. You can also test for yourself:

if col1 is nvarchar(500)

alter table MY_TBL alter column col1 nvarchar(2000)

will work fine.

---

Mordechai Danielov