Green squigglies with no helptext to explain why

kalo

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

FabiolaB

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

kalo

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).

lp135

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.

kalo

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. 

mpalmer78

I find this annoying too.

You can turn this off under the Code Analysis Rules.

gnbfilho

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.