| title | FILESTREAM and FileTable System Stored Procedures (Transact-SQL) | |
|---|---|---|
| description | FILESTREAM and FileTable System stored procedures (Transact-SQL) | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| ms.reviewer | randolphwest | |
| ms.date | 06/23/2025 | |
| ms.service | sql | |
| ms.subservice | system-objects | |
| ms.topic | reference | |
| helpviewer_keywords |
|
|
| dev_langs |
|
[!INCLUDE SQL Server]
This section describes the system stored procedures to the FileTable and FILESTREAM feature.
-
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.