Finding line from script error

• alecia.johnson

  Newbie

  Points: 2

  More actions

  September 7, 2010 at 10:03 am

  #157188

  I am running a query and it gives me an error on line 216. Is there some way I can have the system find that line for me to troubleshoot?

• WayneS

  SSC Guru

  Points: 95460

  More actions

  September 7, 2010 at 10:07 am

  #1217413

  Assuming that you're running a query (as stated), and not a stored procedure - just double-click on the error message. That will usually take you to either the line with the error, or the line that is at the start of the command that contains the error.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• alecia.johnson

  Newbie

  Points: 2

  More actions

  September 7, 2010 at 10:09 am

  #1217415

  Awesome, thanks!! I knew there had to be a way.

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  September 7, 2010 at 10:47 am

  #1217443

  If you are a keyboard shortcut person, as I am:-D, you can also use the keyboard shortcut CTRL + G that will bring up the "Go to Line..." prompt.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton