Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Structure for Tables with File Attachments

Status
Not open for further replies.

gavjb

Technical User
Jul 5, 2005
67
GB
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
 
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??
 
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,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top