FILESTREAM and FileTable system stored procedures (Transact-SQL)

Applies to: SQL Server

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.

Related content

• FILESTREAM (SQL Server)
• FileTables (SQL Server)
• FILESTREAM and FileTable Dynamic Management Views (Transact-SQL)
• FILESTREAM and FileTable Catalog Views (Transact-SQL)