128 questions
0
votes
0
answers
16
views
FileTable insert permissions aren't properly working in partial containment scenarios [migrated]
I have two databases, dbGateway and dbGlobal with cross db ownership chaining = 1 and db chaining / trustworthy off.
dbGateway has partial containment and dbGlobal has None.
I create a file table in ...
- 10.2k
0
votes
1
answer
120
views
How can I add and view indexes for a FILETABLE?
I have a SQL Server FILETABLE. I am NOT trying to do FULL TEXT searching. I have a query which uses the file_type column in the WHERE clause. The estimated execution plan suggests a new index. I have ...
0
votes
1
answer
263
views
Trying to insert stream_id from FileTable into SQL table that has a "stream_id" column to reference back to the FileTable, but it is not working
I'm trying to add stream_id from SQL Server FileTable into the stream_id column in category table using the second insert statement in the code below. I am following the code of Dan but after the ...
- 21
0
votes
1
answer
185
views
How to create an Url address for image in SQL Server Filetable
I have saved the image as base64 in the SQL Server FileTable.
Now I want to send the address of this file with API in string format for Android to be displayed with the Picasso library.
Do you have a ...
- 1
0
votes
1
answer
415
views
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 ...
- 11
4
votes
0
answers
723
views
How can I map Sql File Table in Entity Framework Core
Recently the company I work for used SQL Server FileTables. How can I map these tables in Entity Framework Core? This is one of them:
I've searched. There are some solutions like creating a stored ...
- 1,775
-1
votes
1
answer
1k
views
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?
- 3
1
vote
0
answers
207
views
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 ...
- 961
0
votes
1
answer
239
views
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 ...
- 177
0
votes
2
answers
825
views
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 ...
- 343
0
votes
1
answer
1k
views
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 ...
- 773
1
vote
2
answers
3k
views
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 ...
- 1,104
-1
votes
1
answer
96
views
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 ...
- 4,211
0
votes
0
answers
268
views
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 ...
1
vote
1
answer
533
views
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 ...
- 528