I have been trawling the web looking for articles and tutorials on "How to store documents and files on remote SQL server 2005" but have found nothing of any relevance so i have decided to post my question to you the experts. I have an intermediate to advanced knowledge of sql and vb.net 2005/2008. I want to be able to store all types of files on the sql server through the program i have made. all the connections are setup and working and I am currently storing images and text remotely into the server through my program but i dont know how to store actual documents into the database like .mp3 , .doc , .pdf etc. i have an ingcling that i have to convert the documents to binary then store the binary in the database then when i want to read it i then rebuild the binary back into a document. But i don't have a clue how to do this can you please help.