nvchar max

Jul 30, 2010 at 4:26 AM

Hi,

When hooking up a memo text I tried to specify nvchar max but it errors on verification :

The length (max) is not supported in the target veson of SQL server.

I am not exactly a DBA, question is what should I use for memo text i.e. Notes etc.  Should I set the nvchar length to 8000 or something?

Cheers,

Rob

v3.6.0.152

By the way, what is te roadmap for this product - in terms of - will I have to pay a lot ofmoney for it in the near future ?

Coordinator
Jul 30, 2010 at 4:47 PM

There is a SQL 2005 and 2008 target. Please change your model target to 2008 for this to be supported. This property is on the root node of the model.

Jul 30, 2010 at 4:55 PM

Sorry to be a pian but where is the root node ?

Jul 30, 2010 at 5:28 PM

I see it .... sorry,

Thanks for your help.