Question : When using a SQL FileTable table, I would like to store additional metadata for the file such as […]
Tag: filetable
How can I return the full text of a document indexed in SQL Server Full-Text?
Question : I’m using SQL Server 2014 with FileTables to store a large number of documents in different formats. The […]
change file table file stream data folder faces error The container can not be dropped
Question : I want to change file database file stream folder from Drive D to Drive F. I successfully transferred […]
Quality Control: Check file names in a folder against filenames in a table
Question : I have a records system in an Oracle database. The records system is used to retrieve pdf, jpeg, […]
MS SQL attach MDF/LDF without FileTable folder
Question : Is it possible to attach a DB that had a FileTable w/o the FileTable files? We were hit […]
How to get SQL Server filetable path locator for subfolder by its literal path
Question : I have a filetable which have several subtables. For example FileTable ->subtable1 ->->subtable1.1 ->->subtable1.2 ->subtable2 ->subtable3 etc How […]
Restore database with a FileTable
Question : We have a SQL Server 2014 (build 12.0.24457.0) database with two tables in, both are FileStream tables, the […]
Better way to store file receipts
Question : I have a financial system that needs to attach PDF receipts for each record saved on my system. […]
SQL SERVER FileTable/FILESTREAM share suddenly becomes unavailable
Question : We had difficulty setting up a FileTable share on a SQL 2014 instance and after giving up on […]
Backup and restore FileTable files
Question : I’m preparing to use the FileTable feature in SQL Server 2012, but I’m unclear about how backups work […]
- 1
- 2