Re: Text/nText/Image Fields export ?

From: John Kane (jt-kane_at_comcast.net)
Date: 03/02/04

  • Next message: Brian Lawton: "Re: Installing SQLSvr2K Evaluation Version on SQL Client" 
    Date: Tue, 2 Mar 2004 07:37:28 -0800

    Andy,
    A bit of clarification... TextCopy.exe does ship with SQL Server 2000.
    Specifically, you can find this utility under the \MSSQL\Binn\ folder.

    FYI, if you love (somewhat ;-) undocumented features, checkout BII.exe... A
    BCP.exe like utility - "Unlike the bcp utility, the bii utility detects when
    an image field is the destination database field and the input is a filename
    that can be located in the file system."

    Regards,
    John

    "Andy Svendsen" <andymcdba1@NOMORESPAM.yahoo.com> wrote in message
    news:uqAs$Dj#DHA.2316@TK2MSFTNGP11.phx.gbl...
    > 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
    > >
    > >
    >
    >

  • Next message: Brian Lawton: "Re: Installing SQLSvr2K Evaluation Version on SQL Client"