DF053: A deprecated system stored procedure is used.

Last modified: December 25, 2024

The topic describes the DF053 T-SQL code analysis rule.

Category

Deprecated

Message

A deprecated system stored procedure is used.

Description

It is recommended to avoid using deprecated system stored procedures.

Additional information

The list of stored procedures considered as deprecated is as follows:

• sp_addalias
• sp_addapprole
• sp_addextendedproc
• sp_addgroup
• sp_addlogin
• sp_addremotelogin
• sp_addrole
• sp_addserver
• sp_addtype
• sp_adduser
• sp_approlepassword
• sp_attach_db
• sp_attach_single_file_db
• sp_bindefault
• sp_bindrule
• sp_bindsession
• sp_change_users_login
• sp_changegroup
• sp_changeobjectowner
• sp_dbcmptlevel
• sp_dbfixedrolepermission
• sp_dboption
• sp_defaultdb
• sp_defaultlanguage
• sp_denylogin
• sp_depends
• sp_dropalias
• sp_dropapprole
• sp_dropextendedproc
• sp_dropgroup
• sp_droplogin
• sp_dropremotelogin
• sp_droprole
• sp_droptype
• sp_dropuser
• sp_getbindtoken
• sp_grantdbaccess
• sp_grantlogin
• sp_helpdevice
• sp_helpextendedproc
• sp_helpgroup
• sp_helpremotelogin
• sp_indexoption
• sp_lock
• sp_password
• sp_remoteoption
• sp_renamedb
• sp_resetstatus
• sp_revokedbaccess
• sp_revokelogin
• sp_srvrolepermission
• sp_unbindefault
• sp_unbindrule
• xp_grantlogin
• xp_loginConfig
• xp_revokelogin

Noncompliant code example

DECLARE @execute_status INT;
EXEC @execute_status = sys.sp_helpextendedproc @functname = N'xp_cmdshell';
GO