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
4
votes
1 answer

Get FileTable stream_id after creating image with File I/O Api

I tried inserting an image file into SQL Server FileTable directory with File I/O API. I need to get stream_id of inserted image and use it another table as a foreign key. Can anyone help me, how can I get created image stream_id?
Aiyoub A.
  • 5,261
  • 8
  • 25
  • 38
4
votes
1 answer

Create file in Windows Explorer locking FileTable

I just got started using FileTables in SQL Server 2012. I have set everything up on a remote server and got things rolling without any issues. Non-transactional file inserts etc worked absolutely fine. However, when I attempted to create a new…
tobypls
  • 839
  • 1
  • 8
  • 21
4
votes
0 answers

How to grant permission to SQL Server FileTable other Windows users

On SQL Server 2012 I've successfully configured FILESTREAMs and created a FileTable table. I am able to access the FileTable via the UNC path (\\server\share\tabledirectory...). However, I'm stumped as far as how to grant permission so that other…
Dan
  • 1,215
  • 1
  • 10
  • 22
4
votes
1 answer

Backup and restore files FileTable through SQL Server 2012

I'm preparing to use the FileTable feature in SQL Server 2012, but I'm unclear about how backups work with this feature: 1) Does a full database backup include FileTable files? 2) How would I perform the restore of a single file, for example?
Camila Reis
  • 151
  • 1
  • 10
4
votes
1 answer

What's wrong with my Update Trigger for an Sql Server 2012 FileTable

I have a table, 'game.FileAttachments' which has a stream_id column that links to the stream_id column of a File table, 'game.Attachments'. I created an Update trigger on the File table, to update the stream_id on the linked table; reason being,…
Paul Rivera
  • 525
  • 1
  • 8
  • 20
4
votes
1 answer

Use SQL INSERT to Create Directories with FileTable

Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement? This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from…
SliverNinja - MSFT
  • 31,051
  • 11
  • 110
  • 173
3
votes
1 answer

Directory lookup for the file... failed with the operating system error 5(Access is denied.)

I want to create a database on my SQL Server Express in SQL Server Management Studio and when I execute the command I get this error: Msg 5133, Level 16, State 1, Line 1 Directory lookup for the file…
Alex Godo
  • 79
  • 2
  • 7
3
votes
1 answer

Full Text Search for extracting a snippet of the text (returning intended text and it's surrounding)

I'm using SQL file table and for instance I have a saved text file named "SOS.txt" which contains following text For god's sake, save us right now please. We can't survive. Now or never! Now I want to find all files that contain the word save, so I…
Muhammad Musavi
  • 2,512
  • 2
  • 22
  • 35
3
votes
1 answer

Deadlock: Insert into a filetable statements appears to block one another

We are having trouble inserting into a filetable. This is our current constellation, I will try to explain it as detailed as possible: Basically we have three tables: T_Document (main metadata of a document) T_Version (versioned metadata of a…
Jannik
  • 2,310
  • 6
  • 32
  • 61
3
votes
0 answers

Virtual Directory in IIS and sql server filetables

I have an ASP.NET MVC application and which has two virtual directories. The first one (let's name it FirstDir) references some folder on the server (for example C:\SomeDir). I connect to a MS SQL Server Database. This database has a Filetable…
Pupkin
  • 1,211
  • 3
  • 13
  • 30
3
votes
1 answer

SQL Server 2012 Full Text Search on FILESTREAMS with Windows Encrypting File System (EFS)

This is basically a yes/no question, but it is appreciated if the answer includes supporting references and a how-to if the answer is "yes". Strangely, I couldn't find a definitive answer in MSDN or TechNet, and my instincts and experiments lead me…
Todd Sprang
  • 2,899
  • 2
  • 23
  • 40
3
votes
1 answer

SQL Server 2012 FileTable Slow Performance when Creating File (Integrating Lucene.NET)

I have been prototyping an approach to integrating Lucene.NET with SQL Server using SQL Server FileTable. The usage is very convenient and the code is simple - I don't have to do anything special with customizing Lucene.NET. The advantage I seek is…
bkrakower
  • 83
  • 1
  • 8
3
votes
1 answer

How to use SqlFileStream for transactional access to SQL Server 2012 FileTable?

I'm trying to use the SqlFileStream object in a WCF service to get a handle to a specific file that is in a SQL Server 2012 FileTable. I'm able to get the path and transaction context like you would expect with no issues using this piece of code: …
chatterjb
  • 91
  • 1
  • 7
3
votes
1 answer

Opening FileTable Files in c# / .net 4

I have a Filetable containing many different document types (.doc;.pdf;.xls etc). I am writing a small web (C# / .net 4) search app. Search works great using fulltext index with filetable to find content. But I'm struggling to find a way in my app…
user1918525
  • 33
  • 1
  • 4
3
votes
3 answers

150MB csv file stored in SQL 2012 FileTable - how can I query the data to insert into a table

I have a simple database with a Persons table UserId, Name,DOB The table contains 750,000 rows (People). I receive a CSV file that may contain 10 million rows UserId, Address1, Address2, Address3, TownCity, Region, Country, Telephone1,…
Ben
  • 75
  • 7
1
2
3
…
8 9