you can use the DBCC SQLPERF(LOGSPACE)

is there any reason you want to captured the log file growth

you need to let your antivirus scan the file stream folder if any virus detected should quarantine the files , if you delete those file it will end up with...

if you assign the single service account for all your SQL service account. it will be an single point of failure if you have any password policy or account locked...

i dont think you can achive this.

is your sql server part of cluster or it is standalone server.

is there any reason why you want to achieve this way.

this will help you to answer your question https://technet.microsoft.com/en-us/library/cc966412.aspx

if you have the sql access to these column and it will allow you to access the file stream data using your managed api.

you can use the programming code to do it and save the data inside the sql server in your convenient data form

when you try to remove the files , The file must be empty

nice one

very nice

can you tell what is your expected result want to achive.

select sku1 as [SKU 1],sku2 as [SKU 2],

onlinesku as [Online SKU],

case condition when 1 then 'Unworn' when 0 then 'Pre-Owned' else 'No-Status' end Condition

from items

in sql if you use any extended procedure will cause many issue later.

i suggest, while uploading the video file you can save the file path , name and duration...