Why does SQL server indicate wrong line number in stored proc when error occurs in compilation?

Question

I have a big stored proc (6000 lines).
If an error occurs when compiling it, SQL server indicates a line number that does not match the actual line where the error occurs.
SQL server 2005, using SQL server management studio.

Answer 1

Many compilers do this.



They point not to the source of the error but the first spot where there is an actual problem.

This is usually the line after the source of the error. The error points to the beginning of that line instead of the end of the previous.

Answer 2

SQL server has always done this.

Answer 3

Because it Bytes!