Export Images from MS Sql 2000 version 8 to file system
Hi All, I am facing an issue while I am trying to export the image file (i.e jpeg, jpg, png) from Sql 2000 to file system. This is MS SQL 2000 version 8 running on Windows Server 2003 R2. I am new to this project and I don't have much idea on MS SQL. I have table called Image conatin below field image_id - data type INT Picture data type IMAGE I have tried the below but getting error. sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE; but it gives me error like this doesn't exist or this is in advanced option. Please suggest how can i solve this issue.