File Streams

Question

File Streams

Oracle_91

SSChampion

Points: 14548
More actions
December 29, 2009 at 1:59 am

#218989

Hi All,
What is the importance of FileStreams in SQL 2008?
Is this any .NET related stuff?
Any thoughts and suggestions would be appreciated.
Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

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

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

File Stream data type stores the file on a physical folder instead of the database file itself, but we can "insert" or "select" the file just like it was stored on SQL Server database.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

mahesh.vsp (12/29/2009)
Hi All,
What is the importance of FileStreams in SQL 2008?
Is this any .NET related stuff?
Any thoughts and suggestions would be appreciated.
Thanks!

Read the following MS article's

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

Note:

You must install the .NET Framework 3.5 SP1 (or later) to work with FILESTREAM data using System.Data.SqlClient.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/