Structure for Tables with File Attachments

[gavjb]

Hi,

I am in the process of updating our inhouse Helpdesk system, and need to add a table to the system which will hold attachments of documents (mainly word, excel or jpegs)

The files can possibly be a couple of megs in size but will more likly be fairly small files.

Can anyone recommend a datatype and structure for the table, apart from a field to hold the attahcment, the table will hold a ref field (smallint).


Thanks,


Gavin

 

[unclerico]

is it a requirement that the files actually be stored in the database or can you store the physical files on the server and have a field in the table point to the location??

 

[gavjb]

Hi,

I need to be able to store the files on the SQL DB Server (we have loads of space on server compared to file server).

Forgot to mentioned what version of SQL Server we are using, it is SQL Server 2000 (latest service pack)

Thanks,


Gavin,