Solved

Getting line numbers to show for Stored Procedure errors

Posted on 2007-03-21
2
207 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
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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