March 8, 2009 at 8:38 pm
During the sql 2008 install we find the FILSTREAM tab. There are three options:
1. Enable FILESTREAM for Transact-SQL access
2. If 2 is selected then the other option is "Enable FILSTREAM for file I/O streaming access"
3. And if 2 is selected, the third option is "allow remote clients to have streaming access to FILESTREAM data." can be selected.
I don't understand these options. I thought that FILESTREAMs were essentially a file-system based way to deal with BLOBS. So......... we absolutely need to access FILESTREAMs via t-sql (that's option 1). What is the choice they present all about?
Option 2: I thought that FILESTREAMs would be accessed via t-sql (is there another way?) so what is "file I/O streaming access" all about?
Option 3: what does this remote streaming access refer to? I associate "streaming" with file systems not t-sql.
TIA,
Confused Barkingdog
March 9, 2009 at 10:25 am
You can access your Filestream data via T-SQL. However, you can also read your Filestream data directly via a C# (etc) program, without any need to pass the data through SQL Server. The other options allow you to do this.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 9, 2009 at 10:34 am
Thank you "Ten"
I didn't realize (duh!) that developers could access the FILSTREAM object using C#.
Barkingdog
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply