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.
Asked
Active
Viewed 2.0k times
8
HaveNoDisplayName
- 8,291
- 106
- 37
- 47
SQL HELP
- 131
- 1
- 2
- 6
-
You are using Microsoft SQL Server? – Politank-Z Jun 11 '15 at 16:48
-
Yes, i am using Microsoft sql server – SQL HELP Jun 11 '15 at 16:49
-
2I have seen this when I've opened an old .sql file that was probably generated in an older version of SSMS than the one I am currently using. If I click "yes" to normalize and save the file, I never get the warning again for that file. – Tab Alleman Jun 11 '15 at 19:07
1 Answers
9
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).
pmbAustin
- 3,890
- 1
- 22
- 33