Xml and VarChar(MAX) Data type in SQL SERVER 2005

Feb 24, 2010 at 1:07 PM

Hi all,

I've created a model from my SQL SERVER 2005 database. Why the model converted the XML datatype to String?

One other question. Why the VarChar(MAX) isn't supported?


Mar 1, 2010 at 1:07 PM

This was an oversight. The implementation assumes that only SQL 2008 supports this type. It gave a validation error if the model was set to SQL 2005. This has been corrected and will be in the next version. Look for it this week.

Mar 6, 2010 at 7:01 PM

The latest post has support for the MAX length type in 2005. Please download and look.