I had the same problem when I attempted to use the debugger.  The solution that I found was making sure that my local copy of SQL Server Client tools (eg....

Query Analyzer limits the output size by default to 256 characters as mentioned above.  But, even though you can't see all of the data in the results set in QA...

I see you got your answer to the question but I wanted to provide you a sidenote for your leading zero question.

I have used RIGHT function for leading zero adds:

DECLARE...

I had a problem similiar to yours I believe.  When I attempted to debug it would Execute rather than stepping into the code.  This happened when I tried to debug...