Deprecated Column Types

Column data types text, ntext and image are all still supported by all SQL Server editions, but Microsoft has stated that they may be removed in a future version. As such use of these data types is not recommended, and any affected columns should have their data types changed, as shown below. Changing the data types as below is generally a quick change, not requiring any downtime on production servers.

  • text → varchar(max)
  • ntext → nvarchar(max)
  • image →varbinary(max)

Suggested Action

Convert all deprecated column types to the new data types.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

​ntext, text, and image (Transact-SQL) | Microsoft Docs