T-SQL Analyzer

# SQL Server Rule: SML020 | | | |----|----| | Assembly | TSQLSmellSCA | | Namespace | TSQLSmellSCA | | Class | TSQLSmellSCA20 | ## Rule Information | | | |----|----| | Id | SML020 | | Friendly Name | FORCEPLAN should be OFF | | Category | CodeSmells | | Ignorable | false | | Applicable Types | Model | ## Description FORCEPLAN should be OFF ### Examples ```sql CREATE PROCEDURE dbo.Sets2 AS SET NOCOUNT ON; SET DATEFORMAT DMY; SET DATEFIRST 1 SET FORCEPLAN ON SET IDENTITY_INSERT dbo.TestTableSSDT On -- SML008, SML009, SML020, SML022 ``` _{^{Generated by a tool}}