• Currently filestream is not enabled by default...to enable it you must use:

    exec [sp_filestream_configure] @enable = 3;

    Then to see this value..which is what I think the question is getting at:

    "Enabled for Transact-SQL, local file system access, and remote file system access."

    You must run:

    SELECT ServerProperty ('filestreamConfiguredLevel') to see the value of 3.

    Cheers

    -Jeff