UPDATETEXT (Level 2)

Installing SQL Server

Installing SQL Server
UPDATETEXT (Level 2)
SQL Server 6.x SQL Server 2000
UPDATETEXT initialized text columns to NULL, allocating a full 2K page. If the compatibility level setting of sp_dbcmptlevel is 65, UPDATETEXT initializes text columns to NULL. However, if the compatibility level setting is 70 or 80, WRITETEXT initializes text columns to NULL; UPDATETEXT initializes text columns to an empty string.

Expect differences in behavior when initializing text values to NULL (using UPDATETEXT or WRITETEXT) depending on the compatibility level setting of sp_dbcmptlevel.