Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Where can I find SQL error msg???

Status
Not open for further replies.

m0nty005

IS-IT--Management
Apr 24, 2004
27
US
My Application Logs had given me a warning that one of my jobs failed.. It turns out that there was a problem w/ one of my stored procedure I wrote - which has syntactically and logicly been working fine querying data for my reports. Well.. most of my reports works fine, but i've discovered that a few reports was unable to be generated (generated some date but was unable to finish it I presume) My question is How can I find, trace, troubleshoot to where exactly the problem is in my stored proc? Is there a log that will tell me what the exact problem was???

- Help!
 
Nope. However, you can open the stored procedure in Query Analyzer and Parse it (click the blue check mark on the menu). That will catch most errors. If it shows an error in the bottom pane, double click on that error and it will show you the area of your query where the problem is located. QA also has a debugger, but you would have to run the query from QA for it to work. But you should do this when you first create a script of any kind.

-sQLBill

Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top