why i am getting "Inconsistent ending lines" warning window while executing sql script?

Question

When i try to execute a sql script it gives an warning window that

"line endings in the following file are inconsistent. Do you want to normalize it?".

I just want to know why i am getting this and how can i fix it permanently.please help.

Answer 1

Because you have some lines ended with a CR/LF pair, and some lines ending with just a CR or LF (basically mixing Apple, Unix, and Windows conventions somehow). If you're copying and pasting from one editor into MSSMS, it could be that editor handles line-endings differently. You should pretty much just normalize them when it happens. To fix it permanently, you'll have to figure out where the mixed line-endings are coming from (most likely from your copy/paste source).