SQL Compare missed a difference between two stored procedures

in SQL Compare
SQL Compare missed a stored procedure where there was a space before a colon - see attached. 

Tagged:
Best Answer
-
sam.blackburn Posts: 224 Gold 2
In the edit project dialog, do you have the Ignore Whitespace option checked?Software Developer
Redgate Software
Answers
White-space should be classed as the white-space around statements, not within a literal string.
If a statement is preceded with 2 tabs instead of one that's no issue, but if there is a string/code different then that is a major issue if it gets missed.
SQL Compare should be smart enough to pick up the difference between the two.