garyttu
asked on
File attachments in SQL Server
I have a website where I have some cfm pages with a sql server 2000 backend...some of the forms in cfm will have attachments (word docs, etc.)...Is it an issue just creating an attachment table in the sql database and store the file there or is it better to store it in a ntfs file location and store a link to it in the sql server? Our database isn't anything enormous, but still looking for best practices in terms of speed and data integrity.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.