SQL server 2008 file stream

Question

Post reply

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLRockstar SSCertifiable Points: 7014 More actions · Answer 1

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: 150467 More actions · Answer 2

Managing Unstructured Data with SQL Server 2008

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 3

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 · Answer 4

hi

Any guess for the question wating for any replay

Thanks

Parthi

Thanks
Parthi

HowardW One Orange Chip Points: 29109 More actions · Answer 5

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