Deprecated Features

This analysis group contains the rules for finding usage of SQL Server deprecated features.

See Also

Other Resources

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
SA0157 : Usage of three and four part column names is deprecated. Two-part names is the standard-compliant behavior
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
SA0161 : Current database uses old SQL Server collation. To take full advantage of SQL Server features, for new development change the default installation settings to use Windows collations
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
SA0205 : The backward compatibility views for SQL Server 2000 system tables are deprecated. Use the current SQL Server system views instead
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
SA0214 : The CREATE TABLE, ALTER TABLE, or CREATE INDEX syntax without parentheses around the options is deprecated
SA0215 : The CREATE RULE and DROP RULE statements are deprecated
SA0216 : The TORN_PAGE_DETECTION option of ALTER DATABASE is deprecated. Use the PAGE_VERIFY option instead
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
SA0225 : The usage of the NOLOCK and READUNCOMMITTED table hints is are deprecated in UPDATE, DELETE and MERGE statements
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
SA0229 : This syntax of RAISERROR is discontinued. Rewrite the statement using the current RAISERROR(…) syntax or consider using THROW