Line numbers reported by tools on errors

From: Stephen Ahn (noaddress_at_noaddress.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 11:01:01 +1000

Using SQL server version 8.00.760
Given two scripts :

Script A :
==
print 'xyz'
exec dbo.doh
==

Assuming stored proc 'doh' does not exist, when
I run the above as one batch in Query Analyzer,
I get the result :
==
xyz
Server: Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'dbo.doh'.
==

Now Script B :
==
print 'abc'
select * from doh
==

Assuming table 'doh' does not exist, I get :
==
abc
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'doh'.
==

The line number reported for the error in script A is :
'Line 2', which make sense, but the
line number reported in script B is 'Line 1',
which seems strange.

Can anyone shed any light into this ?
Thanks,
Stephen

Relevant Pages