I worked the above with Cast to varchar when updating the TitleNormal.

Convert your dataset to xml and pass xml string to stored procedure.
In procedure you can extract the xml string into a temp table and do the rest.

HI Thanks for replying.So can i just disable the Microsoft Volume Shadow copy service from Services? or do i need to go through programs and uninstall the Feature to get...

Create a Temp table with exact structure of the xml

Open the xml document using sp_xml_preparedocument and then insert the data from xml into the temp table created above.

Once inserted...

Try this.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%foobar%'

AND ROUTINE_TYPE='PROCEDURE'

Replace foobar with the string you are...

Hi,thanks for replying.I found the problem.But still i didn't find the solution.The problem is not the autual table where i do the fulltext search.In the stored prcodeure,which i am using...