It worked:-)

Thanks

dipali

Thanks so much for your replies. I will try with NVARCHAR.

Regards

dipali

SP has following code for writing to the disk. Aprat from this, it has some error handling code.

Select @FileAndPath=@path--+'\'+@filename

if @HR=0 Select @objErrorObject=@objFileSystem , @strErrorMessage='Creating file "'+@FileAndPath+'"'

if @HR=0 execute @hr =...

No I don't have the fonts installed on my machine. Actually we insert single item rss xml file into one of the xml type column. Then combine xmls into...