SA0222 : The ALTER LOGIN WITH SET CREDENTIAL or ALTER LOGIN WITH NO CREDENTIAL syntax is deprecated

The topic describes the SA0222 analysis rule.

Message

The ALTER LOGIN WITH SET CREDENTIAL or ALTER LOGIN WITH NO CREDENTIAL syntax is deprecated

Description

The rule check T-SQL code for the deprecated feature syntax ALTER LOGIN WITH SET CREDENTIAL or NO CREDENTIAL.

How to fix

Use the ALTER LOGIN ADD/DROP CREDENTIAL syntax instead.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix
20 minutes per issue.
Categories

Deprecated Features, Bugs

Additional Information
Example Test SQL
SQL
Copy
1ALTER LOGIN Joe2 WITH CREDENTIAL = Custodian04;
2ALTER LOGIN Joe2 WITH NO CREDENTIAL
3
4ALTER LOGIN Joe2 ADD CREDENTIAL Custodian04; 
5ALTER LOGIN Joe2 DROP CREDENTIAL Custodian04;
Analysis Results
  Message Line Column
1 SA0222 : The ALTER LOGIN WITH SET CREDENTIAL or ALTER LOGIN WITH NO CREDENTIAL syntax is deprecated. 1 17
2 SA0222 : The ALTER LOGIN WITH SET CREDENTIAL or ALTER LOGIN WITH NO CREDENTIAL syntax is deprecated. 2 17
See Also

Other Resources

Analysis Rules