[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Storing and retrieving large Text, Images and video files in MS Sql Server 2000 database.

Hi,

Can any of you please tell me how can I store large text, images and video files in MS Sql Server 2000 database. Also please tell me how can I retrieve these information. I am not very good at database part, so please be a little bit descriptive.

Thanks!

Run2004
0
run2004
Asked:
run2004
2 Solutions
 
RichardCorrieCommented:
0
 
danblakeCommented:
If just using SQL-Server refer to:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20501232.html?query=image+import&searchType=topic

If you wish to do this using Bulk insret, please let me know.
0
 
ShogunWadeCommented:
"an any of you please tell me how can I store large text, images and video files in MS Sql Server 2000 database"

in a nutshell store the file in a folder somewhere and save the UNC name in the database.   You are asking for trouble putting this sort of stuff in SQL server  and you'll regret it in the end.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now