2012-09-03 SqlCodeGuard.2.1.4628
[+] added USE {DBNAME} and "ALTER" on view object definition
[+] added "isssue groups" to "Select issue window"
[+] added API to use in own build process/tools/so on
[+] added sample app for API usage
[*] changed default set of issues - all issues except [DEP023] Not ending Transact-SQL statements with a semicolon is deprecated

LoadObjects:unable to find table in table list:<DB>.dbo.sysdiagrams

SqlCodeGuard.Core.Database.RuleExecutorDelegate:Object reference not set to an instance of an object. at <spTest> (??)
   at ?.??(DatabaseObject ?)
   at SqlCodeGuard.Core.CodeGuardAnalyser.?(Object ?)

CREATE PROCEDURE [dbo].[spTest]
AS BEGIN
	SELECT	 1
	FROM	(SELECT(								-- Обязательно
			SELECT	Row_Number()OVER(ORDER BY name)				-- Обязательно
			FROM	sys.columns
			FOR XML Path(''),Type).value('text()[1]','NVarChar(max)')	-- Обязательно
		)C(X)
END
GO

FOR XML Path(''),Type).{|}value('text()[1]','NVarChar(max)')

<root>
	<objects>
		<object type="P" count="351"/>
		<object type="V" count="1394"/>
		<object type="U" count="1672"/>
		<object type="IF" count="2"/>
		<object type="FN" count="28"/>
		<object type="TR" count="6"/>
	</objects>
	<issues>
		<issue code="BP001" count="6"/>
		<issue code="BP002" count="48"/>
		<issue code="BP004" count="868"/>
		<issue code="BP005" count="1430"/>
		<issue code="BP006" count="168"/>
		<issue code="BP008" count="332"/>
		<issue code="BP010" count="1"/>
		<issue code="BP011" count="1"/>
		<issue code="BP012" count="33"/>
		<issue code="BP013" count="448"/>
		<issue code="BP014" count="36"/>
		<issue code="BP015" count="307"/>
		<issue code="BP016" count="62"/>
		<issue code="CGUNP" count="183"/>
		<issue code="DEP019" count="278"/>
		<issue code="DEP021" count="26"/>
		<issue code="DEP026" count="14607"/>
		<issue code="DEP027" count="84"/>
		<issue code="EI001" count="12"/>
		<issue code="EI002" count="6"/>
		<issue code="EI003" count="51"/>
		<issue code="EI009" count="2"/>
		<issue code="EI010" count="28"/>
		<issue code="EI011" count="56"/>
		<issue code="EI012" count="56"/>
		<issue code="EI013" count="56"/>
		<issue code="EI014" count="2"/>
		<issue code="EI015" count="10"/>
		<issue code="EI016" count="35"/>
		<issue code="EI017" count="9"/>
		<issue code="EI018" count="113"/>
		<issue code="EI020" count="2"/>
		<issue code="EI024" count="216"/>
		<issue code="EI025" count="215"/>
		<issue code="EI026" count="14"/>
		<issue code="EI027" count="5550"/>
		<issue code="MI002" count="4"/>
		<issue code="MI003" count="5405"/>
		<issue code="MI005" count="127"/>
		<issue code="PE001" count="271"/>
		<issue code="PE002" count="4097"/>
		<issue code="PE003" count="270"/>
		<issue code="PE006" count="408"/>
		<issue code="PE007" count="4"/>
		<issue code="PE009" count="296"/>
		<issue code="PE010" count="16"/>
		<issue code="PE015" count="325"/>
		<issue code="PE017" count="2"/>
		<issue code="PE018" count="325"/>
		<issue code="ST001" count="421"/>
		<issue code="ST002" count="391"/>
		<issue code="ST003" count="329"/>
		<issue code="ST005" count="649"/>
		<issue code="ST006" count="192"/>
		<issue code="ST007" count="10"/>
		<issue code="ST008" count="115"/>
		<issue code="TBL001" count="1"/>
		<issue code="TBL002" count="1001"/>
		<issue code="TBL003" count="1021"/>
		<issue code="TBL004" count="9"/>
		<issue code="TBL005" count="42"/>
	</issues>
</root>