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

SQL Server Filetable in different local disk

Can I change filetables share disk? I've enable filestream on my db with a script like this DECLARE @dbName varchar(50), @pathFileStream varchar(max), @directoryNameFS varchar(max), @sql …
cirio
  • 11
  • 1
  • 4
0
votes
1 answer

Making Folder with Access to a SQL FileTable

I am trying to find a way to have Access automatically create a folder in a SQL Server FileTable directory that corresponds with the record itself. I was able to get the code working when inserting the directory onto the main common drive at our…
kanderson
  • 178
  • 2
  • 13
0
votes
2 answers

File Table (SQL Server 2016) FILESTREAM permissions lost in IIS

I am trying to store images in a FileTable that is accessible from a website. According to my understanding, the FileTable needs "SELECT" granted to the account running ApplicationPool that the website runs in. Example of what I have: IIS (6.2)…
Alocyte
  • 293
  • 4
  • 13
0
votes
1 answer

Convert string to HierarchyId in Fluent API (EF Core) using "HasConversion()" or any other method?

I am using FileTables with EF Core Code First approach. I have used stored procedure to get the Path_Locator (PK) from FileTable (named as 'DocumentStore') in string and now attempting to insert the same in another table where I store information…
Imran Faruqi
  • 663
  • 9
  • 19
0
votes
2 answers

SQL Server FILESTREAM filetables with millions of files

I just wanted to ask if it is safe to design a file table that in future will hold about 5-15 million of 0.5-10mb max files? Will NTFS handle it? I had a problem once on old Windows Server 2008 R2 that when I had a folder with more than 2.5 million…
d00lar
  • 802
  • 7
  • 25
0
votes
0 answers

Checking if a file exists in a FileTable considering subdirectories

I am using a FileTable in SQL Server 2017 and I am doing a dating system to store files on it. Example: Filetable directory\2020\1\19 - is today's directory, first the year, then the month, then the day. It all works great but only one thing left,…
Osayed Zaheda
  • 1
  • 5
0
votes
1 answer

Inserting into FileTable gets slower as files increase

I am using FileTables in MSSQL 2017 to save & load images, but whenever the images in the FileTable get high in numbers the increase query takes longer to execute. I disabled 8.3 generation names just in case it's the problem. Here is my Insert…
Osayed Zaheda
  • 1
  • 5
0
votes
0 answers

FileTable: error renaming file name through network share

I've added Filestream to an existing SQL Server 2017 instance. I've already activated Filestream support in the SQL Server services configuration: I've also updated the instance so that is has full access to the filestream: And I've also…
Luis Abreu
  • 4,008
  • 9
  • 34
  • 63
0
votes
2 answers

SQL Server Filetables/FileStream: Insert more than 2GB via Transact SQL?

I want to copy a file to an SQL Server Filetable using T-SQL. I cannot use the Win32 API (or SqlFileStream class for that matter) because the server does not expose SMB. The following code works very well for smaller files (up to 1GB): using…
final
  • 203
  • 1
  • 8
0
votes
1 answer

How to delete documents from Filetable?

I am trying to delete some documents from sql server's filetable. Here I have one table in which I am storing all my Attachment's details and Documents in sql server's file table named Attchemnts. AttachmentDetails table has below schema, CREATE…
Madhav
  • 559
  • 2
  • 11
  • 34
0
votes
1 answer

Access denied when copying file from File Table unc path to a file server

I have a file table with FULL non-transactional access. It can thus be browsed like any file server as well as inserted directly via T-SQL. I wrote a simple SQL CLR C# to copy files from the file table to a file server. The user doing the copy is…
Bukester
  • 23
  • 6
0
votes
1 answer

filetable inserted duplicate key for "stream_id" column

I have a stored-procedure which will save a file into a filetable table: DECLARE @table1 TABLE (id NVARCHAR(50)) INSERT INTO FileTable1(file_stream,name,path_locator) OUTPUT inserted.stream_id INTO @table1…
Rzassar
  • 2,117
  • 1
  • 33
  • 55
0
votes
1 answer

How to create a FileTable in SQL Server LocalDb?

I installed SQL Server 2016 Express LocalDb alongside Visual Studio 2017. Googling "creating a FileTable" leads me to Enable the Prerequisites for FileTable which needs Enabling and configuring FILESTREAM. It says: In the SQL Server Configuration…
Ali Fathi
  • 15
  • 3
0
votes
0 answers

Filetable SQL Server, subfolder permissions. Need to revoke modify permissions

I have an important business requirement as the files can be created but not to be modified in filetable in SQL Server. I have tried playing with permissions and triggers with no success as deny update doesn't work as it snatches away the right to…
Jimmy
  • 17
  • 1
  • 4
0
votes
0 answers

Alter SQL FileTable Location From SQL Server Machine To Another Machine

I want to run This Command To Replace Location of SQL FileTable from Local Location To Another Location In Another Machine like That ALTER DATABASE MyDb modify FILE (NAME='name', FILENAME=N'\\192.168.10.229\FolderName') But I Get This ERROR "The…
Mohamed Elsayed Ali
  • 93
  • 1
  • 7
1 2 3
…
8 9