Thanks for the answers guys, unfortunately niether of them did the trick :(. I've decided just to add to a C# app that I've already written and use the SMO.

george sibbald

sp_helptext doesn't work with BCP properly, I found a couple of ways of doing it but they were far more complex than using SMO.

bitbucket-25253

Yup I had already tried that in SSMS (Thats how I constructed the query in the first place) and it pumped out the whole sp, BCP has a character limit for which there does not appear to be a switch to override.