I would like to know if we can store objects like Excel /
Word / Scanned Image documents in SQL server 2000. Is it
possible to store like in Oracle 9i etc.
Thanks
chitra

Yes it is possible.

In DTS you can use the READFILE/WRITEFILE combination

Write File Transformation
http://www.sqldts.com/default.aspx?6,107,294,0,1


Microsoft when setting up SQL Sever use a batch file and TEXTCOPY to copy in
i,ages to Pubs.


There are other methods also (AppendChunk,GetChunk)

http://www.dwam.net/iishelp/ado/docs/adomthx1_2.htm
--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Chitra" <chitra.prakash (AT) fmcti (DOT) com> wrote

Allan Mitchell ,
Thanks.
So does it mean that pointer to the NFS file is stored in
the SQL server database and not the object itself.

In such a case how does the user be able to edit the
excel/word/image document from Internet Browser (which is
the front end for the SQL server using ASP.
Could U guide me , please
thanks
chitra

No.

You either choose to store it in the DB or you choose to store it on the
file system and point to it

1. If in DB then DB can become huge but it means that if you move the DB
the images go with.
2. If on the filesystem the DB stays smaller but if you move the DB the
links are broken.

I would recommend getting Kalen's "Inside SQL Server 2000" and reading her
discussion

Have a look also at

http://support.microsoft.com/default...NoWebContent=1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"chitra" <chitra.prakash (AT) fmcti (DOT) com> wrote