SQL Server 2005 table, nvarchar(max) columnType

[jakubbukaj]

Hello,
I would like to ask you how to set column type to nvarchar(max)? When I am creating new column in table of sql server 2005 type there is only nvarchar type for selection. Lenght must be specified (from 0 to 4000) and I did not found any way how to set length to "max". I am using EA 7.1.833 which should supported this feature (according to Release Notes for EA 7.1).

I was looking at google, help, forum but without success.

Thanks for help

[«Midnight»]

See the post from Sparx here for a way around this. Also make sure your are using a recent client driver as noted here.

This is not a particularly good solution - it requires user intervention to perform what should be a standard task - but at least it works.

Note that you will have to export and import reference data to use this solution with other models. You could always make this change in your base model so that it would be propagated to new projects.

HTH, David

PS: I urge you to send a bug report to Sparx regarding this. Perhaps they will (someday) update the core product to include this information for SQL Server 2005 and 2008 (and perhaps 2000 if applicable). Use the Report a Bug link under the Support link near the bottom of any forum page.