Sql Server 2008 Express中的文件流 [英] Filestream in Sql Server 2008 Express

问题描述

我试图使其正常工作，但我似乎从来没有碰运气，我去了一个博客的代码段，但仍然没有骰子.这是代码.

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

推荐答案

您需要在服务器上启用文件流，在要使用它的数据库上启用文件流，然后，创建具有文件流类型的表.

You need to enable filestream on the server, on the database you're going to use it and after all this, create a table with filestream type.

请尝试以下链接中所述的步骤:

Try the steps described in the linked below:

http://www.mssqltips.com/tip.asp?tip=1838

http://www.mssqltips.com/tip.asp?tip=1850

或在此处阅读:

1)如何:启用FILESTREAM

http://technet.microsoft.com/en-us/library/cc645923.aspx

2)如何:创建已启用FILESTREAM的数据库

http://technet.microsoft.com/en-us/library/cc645585.aspx

3)如何:创建用于存储FILESTREAM数据的表

http://technet.microsoft.com/en-us/library/cc645583.aspx

如果此步骤无济于事，请提供更多有关您遇到的问题的信息.

Please, provide more information on what kind of issues you've faced, if this steps won't help.

祝你好运！

这篇关于Sql Server 2008 Express中的文件流的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！