Restore a single file from the database

Hello,
We have running sql2000 and we want to use a database where users can store
files in it. My question is: is it possible to restore a single file from
that database?
Thanx in advance
Marco Gorissen
marco.gorissen@.icts.unimaas.nlHi,
You can use text data type with file name as a different column. Using this
you can retive a single file from the SQL table.
select textcolumn from table where filename='filename.txt'
Did I answer your question correctly ?
Thanks
Hari
MCDBA
"Marco Gorissen" <marco.gorissen@.icts.unimaas.nl> wrote in message
news:e0R3b2c1DHA.3216@.TK2MSFTNGP11.phx.gbl...
> Hello,
> We have running sql2000 and we want to use a database where users can
store
> files in it. My question is: is it possible to restore a single file from
> that database?
> Thanx in advance
> Marco Gorissen
> marco.gorissen@.icts.unimaas.nl
>