Groups > comp.databases.ms-sqlserver > #102

SQL Server 2008 SSMS Error Line Numbers

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	SQL Server 2008 SSMS Error Line Numbers
Date	2011-04-04 20:04 -0700
Organization	A noiseless patient Spider
Message-ID	<291lp6plrgb2on2h6madjkhd3o8idpc2fg@4ax.com> (permalink)

Cross-posted to 2 groups.

Show all headers | View raw

Dear SQLers:

     Occasionally, I make an error and SSMS reports this.

     Actually, I make a lot of them.  There is a frustration that the
line number given by SSMS is rarely the line in my .SQL file since I
have a lot of GOs in it.  I am putting together a simple database a
bit at a time, and I find it easier to drop it and restart on each
change so as to simplify debugging.

     How do I find out the actual line number?  If I am fortunate
enough to recognise the GO section where the error is, I can position
to the beginning and add the error line number given minus one to get
the actual line number.  This is tedious.  If I can not tell which GO
section met with disapproval, it is even worse.  This is even more
tedious.

     Please tell me that I am overlooking a setting.  And what it is,
course.  I will probably post the .SQL once I have finished.  There
should be a few procedures in it worth snagging.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

SQL Server 2008 SSMS Error Line Numbers Gene Wirchenko <genew@ocis.net> - 2011-04-04 20:04 -0700
  Re: SQL Server 2008 SSMS Error Line Numbers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-05 08:47 +0200
  Re: SQL Server 2008 SSMS Error Line Numbers Erland Sommarskog <esquel@sommarskog.se> - 2011-04-05 07:32 +0000
    Re: SQL Server 2008 SSMS Error Line Numbers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-05 10:04 +0200
    Re: SQL Server 2008 SSMS Error Line Numbers Gene Wirchenko <genew@ocis.net> - 2011-04-05 12:47 -0700
      Re: SQL Server 2008 SSMS Error Line Numbers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-05 21:56 +0200
      Re: SQL Server 2008 SSMS Error Line Numbers Erland Sommarskog <esquel@sommarskog.se> - 2011-04-05 22:44 +0200

csiph-web