Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server 2008 file stream Expand / Collapse
Author
Message
Posted Wednesday, March 31, 2010 7:00 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195

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
Post #893728
Posted Wednesday, March 31, 2010 7:18 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 9, 2014 3:55 PM
Points: 3,000, Visits: 471
i'm not sure i understand the question, do you need instructions on how to enable FILESTREAM?

----------------------
http://thomaslarock.com
Post #893743
Posted Wednesday, March 31, 2010 10:10 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 9,928, Visits: 11,195
Managing Unstructured Data with SQL Server 2008



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #893943
Posted Monday, April 5, 2010 8:46 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195
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
Post #896752
Posted Friday, August 6, 2010 9:36 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195
hi
Any guess for the question wating for any replay

Thanks
Parthi


Thanks
Parthi
Post #965260
Posted Friday, August 6, 2010 9:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 3, 2014 8:05 AM
Points: 1,191, Visits: 9,892
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

Post #965286
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse