Re: Text/nText/Image Fields export ?

From: Andy Svendsen (andymcdba1_at_NOMORESPAM.yahoo.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 12:14:35 -0500

Read the earlier post from Noor --> Script. I didn't think this could be
done, but one person who replied, Hari, mentioned a utility TEXTCOPY.
Below is what I found out about, exactly why it is not found in SQL books
online, I do not know. It doesn't come with SQL 2000, so far as I can tell,
but I'm looking. In SQL 7, look for textcopy.exe in the default program
directly -- c:\mssql7\binn. I love undocumented features.

http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm

Otherwise, SQL 2000 books online is going to tell you do it programatically.
textcopy is described as a sample utility. 

-- 
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
"WJ" <JWebb@Msn2.Com> wrote in message
news:eYEXM6$9DHA.1128@tk2msftngp13.phx.gbl...
> I have a table that store MS/Word and Excel files via Image and nText data
> type. How can I select these fields using SQL/Analyzer tool to write these
> files back to the hard disk in their original Word/Excel formats ?
>
> Thanks for your help,
>
> John
>
>