How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Kris R Your Own Question
Kris R
Kris R, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 2842
Experience:  IT Manager at Wood Group PSN
94743361
Type Your Computer Question Here...
Kris R is online now
A new question is answered every 9 seconds

In SQL server, when you're editing a stored procedure and

This answer was rated:

In SQL server, when you're editing a stored procedure and you execute it, how do you hide the messages pane at the bottom so as to see a full page view? And how do you see the line numbers in the SP?

Customer: replied 1 month ago.
I meant to say after you've executed it.
Customer: replied 1 month ago.
Forget the first. You select hide the results pane. But would like to see the line number.

Hi
Sorry for the delay, we are busy and I've just got to your question.
How long has this been happening?
Thanks
Kris

Customer: replied 1 month ago.
No idea. Must be a setting. I want to find this :Msg 102, Level 15, State 1, Procedure vsp_rpt_arslip, Line 126 [Batch Start Line 18] Incorrect syntax near ','.

What version of SQL is it? MS or My?

Customer: replied 1 month ago.
SQL server management studio version 17.2

Can I connect please and show you? The lines are on the top part of the SQL execution..?

Customer: replied 1 month ago.
Can't do from this computer. Just tell me where it is.

Can you send me a screenshot please, I think you're seeing somthing differnt fro mwhat I am

Customer: replied 1 month ago.
Here it is. Maybe it's here and I'm just not seeing it.

To enable line numbers in Query Editor windows, follow below steps:

  1. Step1: Go to Tools > Options.
  2. Step2: In the Options dialog box navigate to Text Editor > Transact-SQL > General.
  3. Step 3: Check “Line Numbers” and click on “OK”

Note: Can you rate me at the top 5/5 out gives me the top credit

Kris R and other Computer Specialists are ready to help you
Customer: replied 1 month ago.
Great. Thank you!