On new insert i need to retrieve the newly created id field. it was working until i was using sql, but i am using the FOR XML and it gives me an error that this property is not supported. Is there a way in which i could retrieve the newly created id from the DB in an XML format