---------U need to use a fetch row sintax

---------I did a quick script for u , u need to do something similar.

-- Declare the variables to store the values returned by...

---------U need to use a fetch row sintax

---------I did a quick script for u , u need to do something similar.

-- Declare the variables to store the values returned by...

I tried service broker but it works only between 2 instances of sql(if i am right), i have the same problem as u i need to process data instantly i...

Security is not an issue , i am on a intranet , with no internet connections.

Ya , i know but its not my design , i have a application that works with sql (stored procedures,tables) and i only have access to sql ,...

I have a trigger on a table on insert that i wanna send some data via xml to this service on a specific port.