• josephstran (8/28/2008)


    How to I extract binary data greater than 8000 Bytes (varchar(max))? Thank you for any help you can provide.

    varchar(max) != varbinary(max)

    The varbinary(max) can store upto 2GB data.

    You can export the data using the bcp command.

    I've written an example in the article. It will just take awhile if you want to import/export

    big files.