>...is running snippets from an SP in the query analyzer the best way to debug > SP's?

You really need to run your stored procedures from both the QA and oSQL. QA automatically sets some of the connection settings w/o bothering to tell you. The BOL should have those listed. I don't have the BOL handy.\

-Mike