?
Solved

Getting line numbers to show for Stored Procedure errors

Posted on 2007-03-21
2
Medium Priority
?
213 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 200 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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Screencast - Getting to Know the Pipeline

864 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