This is a SQL script that will solve the problem associated with on-premise accounts that still have some ntext fields in their database from older versions of CRM.
The ntext fields do not allow some of the actions that are used in the views of CRM, DISTINCT being an example of one of these commands...
on
11 May 2018