Filestream in Sql Server 2008 Express

Posted by Xaitec on Stack Overflow See other posts from Stack Overflow or by Xaitec
Published on 2010-05-08T22:38:40Z Indexed on 2010/05/10 7:34 UTC
Read the original article Hit count: 380

i tried to get it to work but i never seem to have to luck, i go a code snippet for a blog and still no dice. This is the code.

EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE
GO

CREATE DATABASE NorthPole
ON
PRIMARY (
  NAME = NorthPoleDB,
  FILENAME = 'C:\Temp\NP\NorthPoleDB.mdf'
), FILEGROUP NorthPoleFS CONTAINS FILESTREAM(
    NAME = NorthPoleFS,
FILENAME = 'C:\Temp\NP\NorthPoleFS')
LOG ON (                        
    NAME = NorthPoleLOG,
FILENAME = 'C:\Temp\NP\NorthPoleLOG.ldf')
GO

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2008