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;
sp_configure 'Ole Automation Procedures', 1;
but it gives me error like this doesn't exist or this is in advanced option.
Please suggest how can i solve this issue.