I'm finally getting to use SQL 2008 for the back end on a new project. I was real excited about being able to debug and set break points...but I haven't got it to actually break at the break points. I set a break point, and click the green arrow that says debug and it just flashes the screen and run the code all the way through. In the output window it shows auto-attach to process .... succeeded.

I haven't read the books on line yet on how to debug, but I will someday, until then I was hoping someone could tell me if I'm missing a step or I just misunderstood how this can be used.

Thanks
Kirk