Stack Overflow
Stack Overflow

Questions tagged [filetable]

FileTable helps integrate SQL Server Databases with FileSystem storage by leveraging existing FILESTREAM capabilities.

The FileTable feature brings support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL Server. FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services - including full-text search and semantic search - over unstructured data and metadata.

In other words, you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.

The FileTable feature builds on top of SQL Server FILESTREAM technology. Notably, FileTable allows non-transactional access to the files, something not possible with FILESTREAM.

130 questions
0
votes
1 answer

Working with FileTable and ASP.NET C# (Open a PDF)

I am trying to open a PDF in the browser (or download) PDF's when a user clicks on a link. I found a similar question on SO (Opening FileTable Files in c# / .net 4) and was trying to implement the answer in my code, but have not had any luck. I…
brown1455
  • 57
  • 2
  • 8
0
votes
1 answer

SQL Server 2012 SP 1 - Insert Permissions On Filetable

I am new to SQL server filetable, so I'm trying to get a grasp on how the table permissions affect the file share. What I am looking to do is to allow users to read and create/add files to the file share, but not allow them to update or delete…
mschmit
  • 36
  • 2
0
votes
0 answers

How to hide/disabled the file tab(which also calls backstage view) in word 2010+

I'm developing a web-word control which aims to open the word in web page to edit or save... and I find that there is a tab calls file tab(left/top) in word 2010+, it will open a new window contains many functions, but i don't need it in my control,…
Kenshen
  • 9
  • 1
0
votes
1 answer

Find a whole sentence by SQL Contains command

Search for a whole sentence in a file stored in file table using CONTAINScommand ? For example if user enter "SQL Server" sentence I want to search for files that just contain exactly "SQL Server" not "SQL SOME TEXT Server" I get the following error…
Ali Foroughi
  • 4,540
  • 7
  • 42
  • 66
0
votes
1 answer

Physical file name for filetable sqlserver

I'm creating a custom IFilter for sqlserver, for a my extension (we can call it "abc"). The abc files are generic crypted files, that have originally a different extension and that are recorded in a sqlserver filetable. When I copy a file into my…
gigiuzzo
  • 21
  • 4
0
votes
0 answers

Insert an .sdf file into SQL Server column

I tried using blob: INSERT INTO [dbo].[ProbaImage](Id, Podatak) SELECT 1,* FROM OPENROWSET(BULK N'C:\Users\Desktop\AUTOTROLEJ.sdf', SINGLE_BLOB) AS Podatak GO But it doesn't work, it gives me the error that cannot read…
user1788654
  • 311
  • 2
  • 5
  • 13
-1
votes
1 answer

How can I change filegroup location?

I used filetable for storing files in my project. now I want to change the filegroup location and move it to another drive. How can I do this?
kkarimi
  • 3
  • 1
-1
votes
1 answer

How to map newsequentialid with NHibernate

I am using SQL Server FileTable with NHibernate. On insert, NHibernate will call a stored procedure that inserts a record into the FileTable. The problem I have is that the Id (stream_id) column in the FileTable is generated by SQL Server on insert.…
Luka
  • 4,075
  • 3
  • 35
  • 61
-1
votes
1 answer

SQL Data Compare Tools that compare FileTable data

Does anybody have any recommendations for SQL Data Comparison tools that will compare and synchronize FileTable data? So far I have looked at Visual Studio Data Comparison tool, SQL Delta and SQL Data Compare by Redgate and none of them appear to…
Tracey Penberthy
  • 225
  • 3
  • 8
-1
votes
3 answers

Want to sort of create a distributed file system?

Where I work there is about 400 employees split between several campuses at the two main campuses we have servers set up and shared folders on the servers. I want to setup a system so we have one shared folder that users see but then have copies of…
user802599
  • 787
  • 2
  • 12
  • 35
1 2 3
…
8
9