Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 FILESTREAM Expand / Collapse
Author
Message
Posted Sunday, May 11, 2008 11:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 5:57 AM
Points: 12, Visits: 35
Comments posted to this topic are about the item SQL Server 2008 FILESTREAM
Post #498485
Posted Monday, May 12, 2008 7:24 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:08 AM
Points: 491, Visits: 223
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
Post #498758
Posted Monday, May 12, 2008 8:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 5,597, Visits: 24,985
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.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #498833
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse