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!
- Help!