How would I go about saving the data from an "image" column in SQL2005 to a binary file that I can use to update a row in a different database on a different server? I know that once I get the file, I can use OPENROWSET to read it in to the destination server, but I cannot figure out what the SQL is to extract the contents of the image column to a file.
Any suggestions?
Thanks, Matthew