I want to use sp_xml_preparedocument and give the xml file as an input to it instead of copying the contents of xml file and calling the sp_xml_preparedocument. I need to send the file name and path as an input to stored procedure which internally calls sp_xml_preparedocument. Is there a way to do it? thanks Praveena
I think that you need some kind of an extended stored procedure to read a file from the disk. -- Rediscover the web http://www.mozilla.org/firefox/