Storing documents/JPG files

[hpsingh]

Presently I am using SQL Server 7.0 for my projects.
In my present project I am using VB with SQL Server.Some MS Word documents are added at runtime which are saved in a shared folder. The names of these documents are stored in a table of the database.

I have not yet worked in SQL Server2000 database.I have heard that there are some additional utilities in SQL Server2000. I want to know if there is a provision for storing the MS Word documents directly in a table in SQL Server2000. So that, instead of storing the documents in a folder I can directly save them in a database.

Someone having an idea, in this regard is most welcome.

 

[crystalized]

I think that if you do a search of this forum you will find a couple of discussions about the advantages and disadvantages of storing things like images in your database.

I think most of the discussions were about images more so than documents (at least the last time I looked).

Hope this helps a little, Crystal
crystalized_s@yahoo.com

--------------------------------------------------

Experience is one thing you can't get for nothing.

-Oscar Wilde