在SQL SERVER中创建FILESTREAM的错误 [英] error for create FILESTREAM in SQL SERVER

问题描述

嗨


当在sql server查询中运行此代码时，将生成此错误消息：



< br $>
代码：

Hi
when this code is run in sql server query , this error message would be produced:


code:

CREATE DATABASE MyFsDb
ON
PRIMARY ( NAME = MyFsDat,
    FILENAME = 'c:\data\myfsdat.mdf'),
FILEGROUP MyFsGroup CONTAINS FILESTREAM( NAME = MyFs,
    FILENAME = 'c:\data\myfs1')
LOG ON  ( NAME = MyFsLog,
    FILENAME = 'c:\data\myfslog.ldf')
GO

----------------------------------------------
error message :

Msg 5591, Level 16, State 1, Line 1
FILESTREAM feature is disabled.

谢谢

thanks

推荐答案

启用FILESTREAM功能检查

http://msdn.microsoft.com/en-us/library/cc645923.aspx [<一个href =http://msdn.microsoft.com/en-us/library/cc645923.aspxtarget =_ blanktitle =新窗口> ^ ]

< a href =http://stackoverflow.com/questions/21093255/filestream-feature-is-disabled> http://stackoverflow.com/questions/21093255/filestream-feature-is-disabled [< a href =http://stackoverflow.com/questions/21093255/ filestream-feature-is-disabledtarget =_ blanktitle =New Window> ^ ]

enable the FILESTREAM feature check
http://msdn.microsoft.com/en-us/library/cc645923.aspx[^]
http://stackoverflow.com/questions/21093255/filestream-feature-is-disabled[^]

这篇关于在SQL SERVER中创建FILESTREAM的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！