Large SQL Scripts Fail on Microsoft SQL Server
In some situations, depending on various factors, such as memory available on the Change Assistant workstation, large SQL scripts can fail when run against Microsoft SQL Server. For example, this can occur when running the Microsoft conversion script during an upgrade.
To resolve this issue:
Set the step executing the SQL script to run manually.
Split the script into at least three separate scripts and run them individually.