SQL 无法写入属性 IsFileStream

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/21956076/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 01:08:41  来源:igfitidea点击:

Cannot write property IsFileStream

sqlsql-serverssms

提问by Edd

Everytime I try to create a new Database in SQL—haven't accomplished to create any, so far. Please, help me with a detailed solution for this.

每次我尝试在 SQL 中创建一个新数据库时 - 到目前为止还没有创建任何数据库。请帮我提供一个详细的解决方案。

TITLE: Microsoft SQL Server Management Studio

标题:Microsoft SQL Server 管理工作室

Cannot write property IsFileStream.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo)

无法写入属性 IsFileStream。此属性在 SQL Server 7.0 上不可用。(Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtID=IsFileStream&LinkId=20476

如需帮助,请单击:http: //go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtID=IsFileStream&LinkId=20476



BUTTONS:

纽扣:

OK

好的

采纳答案by EKOlog

Currently you are using preview version of SQL Server 2014 (Community Technology Preview 2) which could be unstable.

目前您使用的是 SQL Server 2014(社区技术预览版 2)的预览版,该版本可能不稳定。

You shoulduse latest stable (RTM) version from http://msdn.microsoft.com/en-us/library/dn434042.aspx

应该使用来自http://msdn.microsoft.com/en-us/library/dn434042.aspx 的最新稳定 (RTM) 版本

回答by altergothen

SQL Server Management is unable to set up the default property while creating a database using previous version of SQL Server Management Studio.

使用 SQL Server Management Studio 的早期版本创建数据库时,SQL Server Management 无法设置默认属性。

回答by Dinesh Gupta

Select the master database and write a query to create database Example create database XYZ

选择master数据库并编写查询创建数据库示例创建数据库XYZ

回答by RBT

There is another possibility which you can check as part of SQL Server instance properties. I'm facing this issue with SQL Server 2014 express edition also. It might be the case that the Filestream Access Levelconfiguration (inside Advancednode) is currently disabled for your SQL Server instance. Try changing it to Full access enabledto resolve this issue. Have a look at the below snapshot -

还有另一种可能性,您可以将其作为 SQL Server 实例属性的一部分进行检查。我也面临 SQL Server 2014 速成版的这个问题。可能是您的 SQL Server 实例当前禁用了Filestream Access Level配置(内部Advanced节点)。尝试将其更改为Full access enabled以解决此问题。看看下面的快照 -

enter image description here

在此处输入图片说明