There are several rules that are only available in SQL Code Guard. And with SQL Code Guard no longer being maintained they should be implemented in SQL Prompt Code Analysis so that we can avoid having to use two products.

By our count here are the rules currently not implemented in Code Analysis:

DEP004 COMPUTE and COMPUTE BY clauses are deprecated
DEP005 FASTFIRSTROW table hint is deprecated
DEP008 PASSWORD/MEDIAPASSWORD options in BACKUP/RESTORE statement are deprecated
DEP010 DBCC CONCURRENCYVIOLATION is deprecated
DEP017 NON-ANSI join (= or =) is used
EI001 Incompatible variable type for procedure call
EI002 Incompatible literal type for procedure call
EI004 Extra parameter passed
EI006 Required parameter is not passed
EI007 Call parameter declared as output
EI008 Call parameter is not declared as output
EI009 Call has more parameters than required
EI010 OPEN of undefined cursor
EI014 Fetch from cursor with asterisk in select list, unable to check columns
EI017 Hardcoded current database name in procedure call
EI019 BEGIN TRANSACTION without ROLLBACK TRANSACTION
EI020 ROLLBACK TRANSACTION without BEGIN TRANSACTION
EI022 Fetch from unopened cursor
EI025 Executing stored procedure without getting result
EI026 Reference to function in other database
EI027 Reference to table or view in other database
CGTIME Timed out
CGUNP Unparsed SQL
MI004 Usage of sp_executesql (only in procedure/trigger)
PE009 No SET NOCOUNT ON before DML
SC001 Script should end with GO
SC002 Script should end with empty line
ST005 IF or ELSE without BEGIN…END block
ST009 Avoid using GOTO to improve readability
ST012 Consider using temporary table instead of table variable
ST014 Procedure name - pattern is not found in allowed patterns
ST015 Procedure name - pattern is found in disallowed patterns