April 22, 2012

sp_filestream_force_garbage_collection (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_filestream_force_garbage_collection(nvarchar @dbname
, nvarchar @filename)

MetaData:

   
create procedure sys.sp_filestream_force_garbage_collection
(
@dbname sysname = NULL, -- name of the database where to collect
@filename sysname = NULL -- FILESTREAM file container name
)
as
begin
set nocount on

set @dbname = ISNULL (@dbname, DB_NAME ())

declare @returncode int

EXEC @returncode = sys.sp_filestream_force_garbage_collection_internal @dbname, @filename

return @returncode
end

No comments:

Post a Comment

Total Pageviews