using CLR Stored Procedure

[lausivcid]

Hi,

Is it possible to read the SqlContext.Pipe.Send? string output of a
SQL Server 2005 CLR Stored Procedure in an external WinForms C#
project?

Thanks,
Lausivcid

[Alberto Poblacion]

"lausivcid" wrote in message
news:gu********************************@4ax.com...

Is it possible to read the SqlContext.Pipe.Send? string output of a
SQL Server 2005 CLR Stored Procedure in an external WinForms C#
project?

Yes, from the client side the Pipe.Send behaves like a PRINT statement in
T-SQL, so you can receive its output in the same way, by means of the
InfoMessage event of your SqlConnection object.