Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

Re: SQL Server 2008 SSMS Error Line Numbers

From Erland Sommarskog <esquel@sommarskog.se>
Newsgroups comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject Re: SQL Server 2008 SSMS Error Line Numbers
Followup-To comp.databases.ms-sqlserver
Date 2011-04-05 07:32 +0000
Organization Erland Sommarskog
Message-ID <Xns9EBE610E94BACYazorman@127.0.0.1> (permalink)
References <291lp6plrgb2on2h6madjkhd3o8idpc2fg@4ax.com>

Cross-posted to 2 groups.

Followups directed to: comp.databases.ms-sqlserver

Show all headers | View raw


Gene Wirchenko (genew@ocis.net) writes:
>      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.
 
Double-click on the error message, and SSMS will do the rest of the work for 
you.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | NextPrevious in thread | 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