loving the code analysis but on some procs i'm getting green squiggly lines but with no explanation when i hover over them - i can script an almost identical proc and not get them

      
      
      
      
Comments
6 comments
- 
                
                   Hi @kalo, Hi @kalo,
 You are getting the green squiggly lines because "The EOL marker sequence is not the expected CR/LF." (see rule SC006). This is being triggered because windows line endings are not being used in your file.
 Hope this helps,
 Regards,
 Fabiola
 
- 
                
                   Thanks Fabiola. Thanks Fabiola.
 Unfortunately it seems to get rid of them I have to use the format-sql option and then undo all the formatting styles that then get imposed on the query (having edited a custom style as close to my liking as possible).
- 
                
                   Why should we care if The EOL marker sequence is not the expected CR/LF? SSMS sometimes complains about this too, but I can't think of any case where it's actually affected how any of my T-SQL code runs. Why should we care if The EOL marker sequence is not the expected CR/LF? SSMS sometimes complains about this too, but I can't think of any case where it's actually affected how any of my T-SQL code runs.
- 
                
                   It doesn't affect how it runs, it's just an annoyance that distracts from proper issues. Ideally if there are zero issues , there should be zero squiggly lines. Any squiggly lines should be capable of being addressed and then disappearing. It doesn't affect how it runs, it's just an annoyance that distracts from proper issues. Ideally if there are zero issues , there should be zero squiggly lines. Any squiggly lines should be capable of being addressed and then disappearing.
- 
                
                   I find this annoying too. I find this annoying too.
 You can turn this off under the Code Analysis Rules.
 
- 
                
                   If you don't want to disable the verification for the rule (maybe you use it on other works), you can select all the query text (Ctrl+A), copy, past it on Windows notepad, copy and paste it back on SSMS query editor, overwriting the existent text. If you don't want to disable the verification for the rule (maybe you use it on other works), you can select all the query text (Ctrl+A), copy, past it on Windows notepad, copy and paste it back on SSMS query editor, overwriting the existent text.
 Worked for me.
Add comment
Please sign in to leave a comment.