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?

Thks!

Coordinator
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.

Coordinator
Mar 6, 2010 at 7:01 PM

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