SQLRNNR (9/5/2013)
Thomas Abraham (9/5/2013)
raulggonzalez (9/5/2013)
Thanks for the question, but it would have been useful if it was specified that is a SQL Server 2012 environment as in previous versions this didn't exist.+1 as I don't use 2012, I responded based on what I knew from 2008. I could have looked up "sp_filestream_force_garbage_collection ", but as another poster said, that just seemed like a made up procedure name. At least I learned something.
Thanks Steve for the question.
Looks like that may have been fixed. When I answered the question, 2012 was specified.
Glad to see that this has been added in 2012 to force GC
Oh that's so cheeky... I want my points back :Whistling: