It would be much easier to get it working the other way arround. Have the
execute the stored procedure. SQL server can listen on any free tcp/ip port.
If you have to communicate with tcp/ip enabled application from stored
procedure than you'll
have to use activex components from stored procedure.
See BOL for:
"Helmut Wöss" <h.woessiis-edv.at> wrote in message
news:3effd363$0$32068$91cee783newsreader01.highwa y.telekom.at...> Hello,
> is it possible to communicate with another program using tcp/ip?
> I mean, i have another program where i know the port number
> and the protokol and what i get back. Now i want to call this
> program using ip number and port number, sending a string to
> it and getting the answer as string back from other program.
> But this should be done with a stored procedure !
> Any way to do this?
> thanks in advance,