I'm making command queries to my mail server via a Socket.TCP object but one of the returns comes back in multiple lines.
I'm using the line
EXEC sp_OAMethod @object, 'GetLine',@output OUTPUT
in my stored procedure to collect the data but because it's more than one line, I'm not getting anything but the first line "200 data follow" and in fact the data in a normal output does follow, but on subsequent lines. I'm declaring @output as varchar (1000).
Does anybody have suggestions on what I can do to collect more than just the first line?