Phil Factor 4 January 2018 Phil Factor 4 January 2018 Finding code smells using SQL Prompt: the SET NOCOUNT problem (PE008 and PE009) Generally, you should prevent rowcount messages being sent, by adding a SET NOCOUNT ON at the start of every stored procedure, trigger and dynamically executed batch. Phil Factor demonstrates, and explains the nuances and exceptions. Read more static code analysis code smells
