Robert
Robert at webedb.com
Fri Jan 30 13:37:03 CST 2009
John, If you are dealing with learning the syntax and issues with it, I would suggest getting SQL Refactor from Red Gate. It will give you an underline at the offending place. It was and continues to be a tool that I use all the time. They have another tool that adds intelli-sense into the management studio that also might be helpful to you. Personally, I have never been able to get debugging working correctly on 2005. Robert ---------------------------------------- > >> My problem in all of this is that I very much a novice at > >> SQL Server. I have been forced to dig in but, like Access, > >> there is just so much to know. If I sit here just > >> "experimenting" trying this and that I get nowhere. There > >> is no "debugger" for SPs so it is "try something, run and > >> see". Worse yet the totality of the feedback is "error near > >> XXX in line YYY", not exactly stellar help.