>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
--sb--