>>I need to change a field in a table from NVarChar(40) to NVarChar(100).
>>Is this possible to do with ALTER TABLE, or do I have to create a tmp table copy records and then drop the table and then rename the tmp table?
>
>Yes, in general, it can be changed with
>
>ALTER TABLE ... ALTER COLUMN ... NVarChar(100)
>
See BOL for limtations
Thanks Sergey. Your reply changed my code from 60 lines to 1 line.
Semper ubi sub ubi.