SEO

#1 (**permalink**) 02-27-2008, 07:09 PM

hi

can SQL Server 2005 enterprise of any other version store documents such as
word, acrobat, Excel
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643

#2 (**permalink**) 02-27-2008, 07:09 PM

Yes - of course you can use it to store those types of files - BLOB's.

You should first to some research on the pro's and con's of going down this
path. Many will argue it's better to let the file system manage your
documents and just store the path on your network to these locations save in
a SQL table.

There are full blown document management systems out there if you're in a
position to purchase them also. If you do decide to store them as BLOB's in
your SQL table's; make sure you model your tables correctly in anticipation
of moving towards a full blown system.

"Pure Heart" <PureHeart@discussions.microsoft.com> wrote in message
news:6347D5FE-7A6B-47FE-AF41-0826C6A7ACAF@microsoft.com...
> hi
>
> can SQL Server 2005 enterprise of any other version store documents such
> as
> word, acrobat, Excel
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

storing documents