Deprecated Features
Introduction
Section titled “Introduction”This analysis group contains the rules for finding usage of SQL Server deprecated features.
Deprecated Features
Section titled “Deprecated Features”Related Topics
Section titled “Related Topics”SA0006 : Non-ANSI inner join syntax
SA0008 : Deprecated syntax string_alias = expression
SA0018 : Support for constants in ORDER BY clause have been deprecated
SA0021 : Deprecated usage of table hints without WITH keyword
SA0053A : Don’t use deprecated TEXT,NTEXT and IMAGE data types
SA0053B : Don’t use deprecated TEXT,NTEXT and IMAGE data types
SA0052 : Avoid using undocumented and deprecated stored procedures
SA0078 : Statement is not terminated with semicolon
SA0092 : The SQL module was created with ANSI_NULLS and/or QUOTED_IDENTIFIER options set to OFF
SA0113 : Do not use SET ROWCOUNT to restrict the number of rows
SA0155 : Deprecated setting of database option CONCAT_NULL_YIELDS_NULL to OFF
SA0155B : Setting CONCAT_NULL_YIELDS_NULL to OFF is deprecated
SA0156 : Statements CREATE/DROP DEFAULT are deprecated. Use DEFAULT keyword in CREATE/ALTER TABLE
SA0158 : Deprecated usage of space as separator for table hints. Use a comma instead of space
SA0159 : Deprecated use of object name containing only # characters
SA0160 : Deprecated use of @, @@, or names that begin with @@ as Transact-SQL identifiers
SA0190 : Numbered stored procedures are deprecated
SA0196 : Deprecated use of DROP INDEX with two-part index name syntax
SA0197 : The deprecated FASTFIRSTROW hint was encountered
SA0198 : Usage of deprecated GROUP BY ALL syntax encountered
SA0199 : Usage of deprecated COMPUTE clause encountered
SA0200 : Backup to tape syntax is deprecated
SA0201 : Textpointers statements WRITETEXT, UPDATETEXT and READTEXT are deprecated
SA0202 : The text and image functions TEXTPTR and TEXTVALID are deprecated
SA0203 : A deprecated system function is used
SA0204 : The system catalog view is deprecated and may be removed in a future version of SQL Server
SA0206 : The sp_configure store procedure executed with a deprecated option
SA0207 : Setting ANSI_NULLS to OFF is deprecated
SA0208 : Setting CONCAT_NULL_YIELDS_NULL to OFF is deprecated
SA0209 : SET OFFSETS is deprecated
SA0210 : Setting FMTONLY option is deprecated
SA0211 : Setting REMOTE_PROC_TRANSACTIONS option is deprecated
SA0212 : The SETUSER is deprecated. It is recommended to use EXECUTE AS instead
SA0213 : The DBCC command is deprecated
SA0215 : The CREATE RULE and DROP RULE statements are deprecated
SA0217 : Usage of GRANT,DENY and REVOKE statement with ALL option is deprecated
SA0218 : The ‘::’ function calling syntax is deprecated
SA0219 : A deprecated build-in function is used
SA0220 : Creating backups with PASSWORD or MEDIAPASSWORD option is deprecated
SA0221 : The FOR SOAP option in CREATE/ALTER ENDPOINT statement is deprecated
SA0222 : The ALTER LOGIN WITH SET CREDENTIAL or ALTER LOGIN WITH NO CREDENTIAL syntax is deprecated
SA0223 : The MODIFY FILEGROUP READONLY and READWRITE syntax is deprecated
SA0224 : The hint is deprecated for use on tables that are targets of INSERT statement
SA0226 : The usage of ROWGUIDCOL and IDENTITYCOL as column name in DML statements is deprecated
SA0227 : The TIMESTAMP syntax is deprecated, use ROWVERSION instead
SA0228 : WITHIN is now a reserved keyword. References to objects or columns named ‘within’ will fail