SA0053A : Don’t use deprecated TEXT,NTEXT and IMAGE data types

The topic describes the SA0053A analysis rule.

Message

Don’t use deprecated TEXT,NTEXT and IMAGE data types

Description

The data types ntext, text, and image will be removed in a future version of Microsoft SQL Server.

How to fix

Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

Scope

The rule has a ContextOnly scope and is applied only on current server and database schema.

Parameters

Rule has no parameters.

Remarks

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Effort To Fix
1 hour per issue.
Categories

Design Rules, Deprecated Features, Bugs

Additional Information

There is no additional info for this rule.

See Also

Other Resources