Query on SQL adapter and Insert updategram

 Hi friends,

I am using SQL adapter and insert updategram to insert data into the SQL server DB. The response i see only contains following

<ns:Outbound xmlns:ns=”http://TestSQL”&gt; <ns:Success /></ns:Outbound>

My requirement is to return two unique fields from SQL server table as response. How can i achieve this. I have tried using at-identity attribute but that is used in the scenario where you are inserting data into multiple tables with parent child relationship. How else can we return the data from the inserted record in the SQL server.

Thanks in advance!!!

Regards,

SKL