May 11, 2008 at 11:33 am
Comments posted to this topic are about the item SQL Server 2008 FILESTREAM
May 12, 2008 at 7:24 am
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
May 12, 2008 at 8:37 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply