Storing Files in SQL SERVER

Posted by Abhisek under Sql Server on 4/4/2010 | Views : 1774 | Status : [Member] | Replies : 1
Hi all,

I am working on a web application and want to store files(.doc, .docx,.pdf,.xls.etc) in the database. I am using SQL SERVER 2005 Express. I also want to retrieve the files from the database. Please tell how to store, retrieve/ download the files to/from the database. Please give me the complete procedure.

Abhisek Panda


Posted by: Abhijit Jana on: 4/4/2010 [Member] [MVP] Bronze

Insted of storing files on SQL Server, store the file path in Database and store the file in physical drive. While retreiving, based on the file path from of SQL Server, retreive the file from Physical location.

Thanks !

Cheers !

Abhisek, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response