Complex Views Truncated

[JNHL]

I'm currently using an evaluation copy of Enterprise Architect 12.

When importing complex views from SQL Server 2012 (SP2) I've noticed that the code is truncated during the import process.

I suspect this is due to the use of the INFORMATION_SCHEMA.VIEWS which hold a truncated version of the code due to the VIEW_DEFINITION field being a NVARCHAR(4000).

Surely a better option would be to use the sys.sql_modules view which holds the definition in a NVARCHAR(MAX), or the OBJECT_DEFINITION() function.

There may be a compatibility issue with the sys.sql_modules and the OBJECT_DEFINITION() function which are only available in SQL 2005 and Later.

I have complex SP's that are greater than 4000 characters, but they appear to be importing ok.

(Edit due to additional research)