SqlCodeGuard full changelog

fixed unparsed with CONTAINS condition
fixed xtra "ST010 Use alias for all table sources" for UPDATE/DELETE statements with single FROM clause item
fixed xtra MI003 "Unqualified column name" on DATENAME(MONTH, GETDATE())
added --# scgignore(all) support

fixed extra MI005 when variable used as EXEC @spname
fixed unparsed on FOR XML ROOT without parameters
fixed error while loading non-clustered indexes from SQL2014
fixed error when @VAR in SET CONTEXT was not resolved as variable

moved to .Net Framework 4.0
added command line utility
added draft support for preprocessor command scgignore - to ignore specifis issues in file
added scgallow(issue)/scgignore(issue`)to control which issues should be registered

sql2014 added to supported sql versions
linked with SIPF 1.0.3.4
added replacements for deprecated system objects
[CGUNP] can be now excluded from issues in msbuild
added TreatWarningsAsErrors option for msbuild
added TreatIssueAsError property for msbuild
added TreatIssueAsWarning propert for msbuild
added [ST013] Non-ANSI NOT_EQUAL operator used (!=)
added bunch of try/catch with log
added exclusion list for [MI001] Table variable is declared but never used
added exclusion list for [MI002] Temporary table is declared but never used
added support message if not all issues copied
added wait cursor for GUI
reset focused item in LV to top after reprocessing
changed order of line/column attributes in produced xml
changed MI005 "Variable declared but never used" and MI006 "Parameter is declared but never used" : now assignments does not counts as usage; variable should be used in expression or as stored procedure parameters
fixed error when SSMS crashes when processing SQL2014 database

added digital sign
added metadata info for ecosystem regisration
added new menu "Settings"
added ability to change settings like BP017AllowedTables and so on
linked with SIPF 1.0.2
fixed xtra MI003 on system functions like CURRENT_USER
fixed issue when info label not hided after complexity analyze
fixed xtra PE009 on UDF
fixed xtra st012 on UDF
fixed unparsed with backward compatibility index options
INSERTED/DELETE and system procedures now not reported as missing from metabase in triggers
changed order of attributes in result file for msbuild
changed sort order in issue list
few informational messages added
in EI025 now printed procedure name
added informational text for cancelling
added "no error found" message after analyze
added few descriptive headers for issues

added TFS Checkin Policy
added Visual Studion 2012 addin
added SQLCodeGuardSettingsEditor - editor for settings files SQL Code Guard API Extended and improved
added Quiet option to msbuild project
added ST009 "Avoid using GOTO to improve readability"
added skip-list for ST009 Avoid using GOTO to improve readability
added ST010 "Use alias for all table sources"
added ST011 Consider using table variable instead of temporary table + ST011AllowedTables
added ST012 Consider using temporary table instead of table variable + ST012AllowedTables
added PE019 "Consider using [NOT] EXISTS instead of [NOT] IN (subquery)"
added EI028 "Adding NOT NULL column without default value"
added EI029 Avoid using ISNUMERIC() function because it accepts int, numeric, float and money numbers
added BP017 DELETE statement without WHERE clause + BP017AllowedTables
added BP018 UPDATE statement without WHERE clause + BP018AllowedTables
added SC001 Script should end with GO/p>

SqlCodeGuard now part of Red-Gate Ecosystem
added early-beta support for msbuild, please look at SampleProject.msbuild in SqlCodeGuard folder
added license file
fixed several CGUNP with MERGE statement
added new issues MI006 "Parameter is declared but never used"
minor refactoring/changes/fixes
removed TBLxxx issues
fixed issue when check incorrectly determines type of object being checked while running analyze from query window

· fixed incorrect line offset in error list
· fixed error with XML.modify and xtra MI005 error
· some cosmetic changes
· added API.GetComplexity() method
· added quot;Categoryquot; field to API.IssueInfo class

· added support for SSMS2012

· quot;Select issuesquot; window made resizable
· Fixed cutting of issues description in quot;Select issuesquot; dialog
· Added quot;Dump issues summaryquot;/quot;Dump issuesquot; to Issue Window context menu
· Added SqlCodeGuardAPI.API.IssueList property to enumerate all defined issues