SQL Server 2008 FILESTREAM

• samiksc

  SSC Enthusiast

  Points: 186

  More actions

  May 11, 2008 at 11:33 am

  #182231

  Comments posted to this topic are about the item SQL Server 2008 FILESTREAM

• Jeff Deluca

  Ten Centuries

  Points: 1152

  More actions

  May 12, 2008 at 7:24 am

  #813777

  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

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  May 12, 2008 at 8:37 am

  #813842

  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[/url]
  Before posting a performance problem please read[/url]