Filestream and FileTable system stored procedures (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

This section describes the system stored procedures to the FileTable and Filestream feature.

Filestream and Filetable system stored procedures

sp_filestream_force_garbage_collection (Transact-SQL)

Forces the FILESTREAM garbage collector to run, deleting any unneeded FILESTREAM files.

sp_kill_filestream_non_transacted_handles (Transact-SQL)

Closes non-transactional file handles to FileTable data.

See also

Filestream
Filetables
Filestream and FileTable Dynamic Management Views (Transact-SQL)
Filestream and FileTable Catalog Views (Transact-SQL)