SQL server 2008 file stream

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  March 31, 2010 at 7:00 am

  #386614

  hi

  I am having a word(.doc or .docx) file in my server i need to import it in database tro file stream (SQL server 2008) how to do. attachement is tro .net(front end ) i will have to brows in that,after getting the path and file i need to save in my database server. how can i do

  Thanks

  Parthi

  Thanks
  Parthi

• SQLRockstar

  SSCertifiable

  Points: 7115

  More actions

  March 31, 2010 at 7:18 am

  #1143059

  i'm not sure i understand the question, do you need instructions on how to enable FILESTREAM?

  ----------------------
  https://thomaslarock.com

• Paul White

  SSC Guru

  Points: 150468

  More actions

  March 31, 2010 at 10:10 am

  #1143239

  Managing Unstructured Data with SQL Server 2008

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  April 5, 2010 at 8:46 am

  #1145763

  Hi

  how to insert a file in my database that is tro attachment.

  i am using browse option in my computer after that i am selecting a file (which may be any formate .txt,.xls,.doc,.docx etc) and saving in the database.in database i am having a table with uniqueid and varbinary(max) field to store the details

  how to store it and retrieve back it

  Thanks

  Parthi

  Thanks
  Parthi

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  August 6, 2010 at 9:36 am

  #1203615

  hi

  Any guess for the question wating for any replay

  Thanks

  Parthi

  Thanks
  Parthi

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  August 6, 2010 at 9:55 am

  #1203639

  Your question is quite vague, but here is a good place to start:

  http://msdn.microsoft.com/en-us/library/a1904w6t.aspx

  Also have a look here:

  http://www.developer.com/net/asp/article.php/10917_3761486_1/Working-with-Binary-Large-Objects-BLOBs-Using-SQL-Server-and-ADONET.htm