Find all columns of a certain type in all tables in a SQL Server database

You can use following query to return fields

SELECT table_name [Table Name], column_name [Column Name]
FROM information_schema.columns where data_type="NTEXT"