The incorrect size is being snapshot for the MSSQL NTEXT data type.
STEPS TO REPRODUCE THE ISSUE
1. Create or drop all tables in a test MSSQL database named "datical."
2. In MSSQL Mgmt Studio, execute the script MSSQL_Incorrect_Types_Snapshotted.sql to populate the 'datical' table with schemas to snapshot.
3. In Datical DB, configure a deployment plan to connect to the test MSSQL server.
4. Connect to the database.
5. Take a snapshot and note the datatypes returned for each changeset.
The NTEXT datatype is being snapshotted as NTEXT(1073741823).
The NTEXT datatype should be snapshot as NTEXT, and not have any size parameter associated with it.
Nathan has a fix for this at commit 9e9299.
This ticket to to track when it gets released.
Windows 7 with Microsoft SQL Server Express 11.0.2100