Solved

Getting line numbers to show for Stored Procedure errors

Posted on 2007-03-21
2
209 Views
Last Modified: 2010-03-19
When I create a SP in 2005 and Parse it for errors using the Server Management Studio, it will display the error message and the line it occurred on in the Results pane, but there are no line numbers in the pane where you enter the code.

Is there a way to get the line numbers to display?
0
Comment
Question by:BendOverIGotYourBack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
mcmonap earned 50 total points
ID: 18768303
Hi BendOverIGotYourBack,

Try: tools, options, expand text editor, select "All Languages", check "line numbers"
0
 

Author Comment

by:BendOverIGotYourBack
ID: 18775690
It's like Christmas all over again.  Many thanks mcmonap!
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question