Save Image Column To File In SQL Server 2000

I have a table with an image column in SQL Server 2000. I need to save the image data to a file on the file system. In SQL Server 2005 I can use the ADODB.Stream object for file

Solution 1:

ADODB.Stream is not a SQL component, is an ADO component distributed with MDAC/WDAC. So simply install latest MDAC/WDAC on the SQL 2000 machine and you'll have ADODB.Stream at your disposal to use.