Hi All,

I have some file management issues associated with database model. I need
to manage 4 individual WORD files into a single document (WORD) and maintain
all the files.

Do you have any suggestions as to whether to store all the files in the
database or just a pointer to the files and have them stored outside the
database? If storing them in or out of database, what would be the data
type for the files respectively? One more thing, If storing the files in
the database makes sense, how shall I manage the 8K row size limit? Is it
simple matter of deciding that the size of the file does not exceed the size
limit when added with other column data types in the table? Guess, if the
file size is too big, it will dictate that the files are stored outside the
database. If there are other reason, I would like to know.

Thank you much.

Sang Nahm
MS Sql Server LazyDBA home page