Filestream and FileTable system stored procedures (Transact-SQL)

• 03/06/2017
• 2 minutes to read
• • M
  • c
  • M
  • M
  • c

Applies to: SQL Server (all supported versions)

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)