Reply To: SQL Server Support

Product Compare Forums Multi-Edit Suggestions SQL Server Support Reply To: SQL Server Support

#5339
herbray
Participant

The “1>2>3>4>” stuff is the line number that you would see had the batch been entered interactively at the SQL prompt. It is also what shows up if you remove the “-n” from the ISQL command tail. I include the “-n” because I don’t want to see all the line numbering garbage in the compiler output pane. The “-n” removes the line numbering completely.

The “2 1” is “Batch” and “Line”, respectively.

Batch____Line_______Error Message

1________1_________Line 1: Incorrect syntax near ‘=’.
2________1_________Line 1: Incorrect syntax near ‘tdate’.

You’re very sharp: Where there is this empty batch (batch #2), DBArtisan is screwing up. It incorrectly points at batch 2, and when you click on the error message, it takes to to the empty batch, but this is typical DBArtisan flakiness.

ISQL, however, correctly identifies the third batch:

1> 2> 3> 4> Batch 1 Msg 170, Level 15, State 1, Server NAVINT-DB\RBC, Line 1
Line 1: Incorrect syntax near ‘=’.
1>Batch 2 1> 2>Batch 3 Msg 170, Level 15, State 1, Server NAVINT-DB\RBC, Line 1
Line 1: Incorrect syntax near ‘tdate’.
1>

– – Herb