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

SQL Server 2012 FileTable not able to open Outlook 2010 email message

I have created a SQL FileTable in a SQL Server 2012 database. I am trying to drag and drop an Outlook 2010 .msg file to the SQL FileTable. I have tried doing this to a Network Drive mapped to the location of the FileTable and also to the original…
Olly
  • 587
  • 1
  • 5
  • 14
1
vote
0 answers

Deleting row from file table using LINQ in .NET Core 3.1

I have an SQL Server with FILESTREAM enabled and a file table populated with a number of rows. I want to be able to delete a selected row from this table using LINQ in .NET Core 3.1. In my infrastructure layer, I have implemented the…
Scopperloit
  • 920
  • 12
  • 23
1
vote
1 answer

How to detect if a table is a FileTable in SQL Server

I am working with an existing SQL script which drops all foreign keys from a database. This runs into trouble if one of the tables is a FileTable. The primary question: is there a way to detect that a particular table is a FILETABLE and skip…
Devon Holcombe
  • 518
  • 1
  • 5
  • 18
1
vote
1 answer

Linking a File Table from Microsoft SQL Server to a table within Microsoft Access 2016

I've used the standard method of linking tables from a Microsoft SQL Server 2012 database into an Access 2016 database. Every table linked correctly except for a File Table. Within Access, the linked table displays the File Table's fields but not…
iaskey
  • 11
  • 3
1
vote
2 answers

Integrating MS Office with PHP & SQLServer Filetables

I have implemented a Document Management System (Web Application) in PHP which stores all documents on SQL server in Filetable. The Software works fine with Downloading the document, modifying it and uploading back to the server. My Question : 1:…
sourabh shinde
  • 27
  • 11
1
vote
0 answers

FileTable file_stream column: "Cannot call methods on varbinary"

I'm trying to use file_stream.GetFileNamespacePath() as documented here: https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/getfilenamespacepath-transact-sql?view=sql-server-2017 using this code: use…
Coy Everett
  • 11
  • 1
1
vote
1 answer

SQL Server FileTable - IP Address instead of Host name

Is there any way to configure SQL Server so that the function FileTableRootPath() returns an IP address instead of the host name? Some of our servers are not in the domain and are accessible only by their IP address.
mshakurov
  • 64
  • 6
1
vote
0 answers

How do you copy a SQL Server filetable directory and its contents recursively to another directory?

I have a SQL Server 2014 FileTable, which contains directories and files. I have been tasked with writing a stored procedure that will copy a directory and all its contents recursively from one location to another within the FileTable. However,…
RebelScum
  • 549
  • 2
  • 5
  • 19
1
vote
1 answer

SQL Server FileTable no access to Share

although I have set all the three checkboxes (Enable Filestream for TSQL, I/O and for remote access) in instance of SQL Server via MMC.exe to true I get the following error when trying to access the Share / FileTable... What could be wrong that…
baer999
  • 810
  • 2
  • 14
  • 26
1
vote
0 answers

Display image from MS SQL FileTable in MVC application

I'm working about application which need to display list of images in table. Currently do it like that: I have save image in app folder In MS SQL - I have ImagePath(src) ex. ("/img/1.JPG") and I use render function in DataTable to display…
krzysztofBy
  • 11
  • 2
1
vote
1 answer

FileTable and Foreign Key from another table

I try to use FileTable with Entity Framework (I know it is not supported directly). So I use custom Sql commands to insert and delete (no update) the data. My problem is I have a table which refers to the FileTable with a foreign key to the…
AlteGurke
  • 585
  • 6
  • 20
1
vote
1 answer

Access to SQL Server FileTable from IIS

After creating filetable I've got a shared folder \\\mssqlserver\\ I've made all nesessary settings in SqlServer Configuration manager to make it available and added couple of files with database stored…
el_konor
  • 528
  • 1
  • 6
  • 15
1
vote
1 answer

Issue with Filestream Filetable not computing file_type column on insert

I am having a problem with my filestream filetable, when I run an insert statement on it the file saves, but the file_type column is null (and obviously cannot be updated manually given that it's a computed column) DECLARE @counter INT,…
bjjrolls
  • 529
  • 4
  • 8
  • 21
1
vote
2 answers

Download Files from File Table SQL Server 2012

I am using a FileTable in SQL Server 2012 and I want my users to download files from the FileTable. What path should I use? public ActionResult DownloadFile(string filename) { //string filename = Request.QueryString["MOVIE_FILE"]; string…
MaazKhan47
  • 811
  • 1
  • 11
  • 22
1
vote
3 answers

SQL Server FileTable : delete file

I use filetable. When I delete files from SQL Server's FileTable, I wantthe files to be deleted from the folder, and when I delete file from folder, it should be deleted from the filetable. And I have a second question: is filetable the faster way…
user2541236
  • 11
  • 1
  • 5
1 2 3
…
8 9