From BOL for 2008

http://msdn.microsoft.com/en-us/library/bb934198(SQL.100).aspx

SELECT SERVERPROPERTY ('FilestreamShareName')

,SERVERPROPERTY ('FilestreamConfiguredLevel')

,SERVERPROPERTY ('FilestreamEffectiveLevel');

FilestreamConfiguredLevel shows the currently configured level of FILESTREAM access, and FilestreamEffectiveLevel shows the effective value of FILESTREAM access. These values might be different if either an instance restart or a computer restart is pending.

When FilestreamEffectiveLevel differs from FilestreamConfiguredLevel and you run sp_filestream_configure without parameters, the results contain an informational message that describes why the values are different.

Effective / Confirured - microsoft's explanation still seems a little vague. But the QOD was clear enough and a good question.