"charles davis" <charlesdavis@w-link.net> wrote in message
news:C06DB7DE.7F88%charlesdavis@w-link.net...
> How would I go about capturing the output of a stored procedure that is
> being returned through a SqlPipe? I have to write a CLR sproc in c#, and I
> need get a string value out of it in the middle of a t-sql script. The
> only
> way that I can figure out how to get the string back out is using the
> SqlPipe. Everything work hunky-dory, and the correct output is written to
> the screen when im in Management Studio, but I really need to shove this
> string into a variable in the t-sql script and I cant for the life of me
> figure out how!
>
> any help, insight, or direction towards information on this subject would
> be greatly appreciated.
>
> TIA
> Charles
>

> Can you send the string back as an output parameter? There is no way to
> capture a message (which is what SqlPipe.Send(string) sends) in T-SQL.
>