SQL Server----FILESTREAM is enabled

Create DATABASE Photorepository on primary

(

Name =n ' Photorepository ',

filename = N ' E:\PhotoRepository.mdf ',

SIZE=5MB,

filegrowth=1024kb

),

Filegroup Fs_photorepository contains FileStream

(

Name= ' Fs_photorepository ',

Filename=n ' E:\FileGroup\FileStream '

)

Log on

(

Name=n ' Photorepository_log ',

Filename=n ' E:\PhotoRepository_log.ldf ',

SIZE=2048KB,

filegrowth=10%)

Go

Today, the time to build a table used this, precisely because FileStream has this article.

Summary: Two-step walk

1. Configure the FileStream property of the DB instance

2. Improve FileStream access level

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

Can see here: http://zhidao.baidu.com/question/328126191.html?qbl=relate_question_0&word=%D3%A6%D3%C3% 20filestream%20%ca%b1%b3%f6%cf%d6%ce%b4%d6%aa%b4%ed%ce%f3

This article is from the "Shang" blog, make sure to keep this source http://6772017.blog.51cto.com/6762017/1432719