how to save soap response in to the sql server database (sav

You could use SOAP extension that store the SOAP request message into XML file, here is a MSDN sample about it, once you get the XML file then load it into XmlDocument and use XPATH to extract data from SOAP message.

http://msdn.microsoft.com/en-us/library/system.web.services.protocols.soapextension.aspx

http://social.msdn.microsoft.com/Forums/en-US/xmlandnetfx/thread/3b3f3cae-713e-48e6-8576-d1e96a4fac79

Otherwise you can stylustudio for sql/xml

http://www.stylusstudio.com/sqlxml_tutorial.html

Otherway :

you can generally store XML in a SQL Server table using normal CRUD procs.  The example below uses an XmlDocument as the source but XML from any source may be used. 

CREATE TABLE dbo.XMLTable(

  XMLTableID int NOT NULL IDENTITY(1, 1) CONSTRAINT PK_XMLTable PRIMARY KEY

  ,XMLColumn xml

);

GO

CREATE PROC dbo.InsertXML

@XmlParameter XML

AS

INSERT INTO dbo.XMLTable (XMLColumn) VALUES(@XmlParameter);

SELECT CAST(SCOPE_IDENTITY() AS int) AS XMLTableID;

GO

var xmlObject = new XmlDocument();

xmlObject.LoadXml("child text");

var connection = new SqlConnection(@"Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=SSPI");

connection.Open();

var command = new SqlCommand("dbo.InsertXML", connection);

command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("@XMLParameter", SqlDbType.Xml);

command.Parameters["@XMLParameter"].Value = xmlObject.OuterXml;

int XmlTableID = (int)command.ExecuteScalar();

connection.Close();