Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-10-28 : 14:43:02
|
| When QA returns SP syntax errors it cites line numbers relative to the procedure start. This is great, but QA lists the absolute line number in the status line. I don't see a relative line number anywhere.I've been counting manually from procedure start to find errors.Is there a convenient way to locate the faulty line?Sam |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-10-28 : 15:30:54
|
| If you have batches in QA (separated by the word GO), errors are reported via the line number of the batch. You might consider changing to a stored procedure where the go isn't allowed. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-28 : 18:42:12
|
Double click on the error message and as if my magic you are transported to the error  or Ctrl+G and enter line number HTHJasper SmithEdited by - jasper_smith on 10/28/2002 18:44:23 |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2002-10-28 : 20:51:15
|
| Jasper,Thanks for that magic trick. It's well hidden behind plain text.Sam |
|
|
|
|
|
|
Syntax errors in long procedures