question

SurojitG avatar image
SurojitG asked

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.
sql-server-2000
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.