更改为sql数据库无法保存 [英] chang to sql database does not get save

问题描述

你好朋友，我已从代码plex站点将数据库下载到sql 2008中的本地计算机上，并且我更改了一个属性的索引并尝试保存该数据库，但是我收到一个错误消息框在保存过程中遇到错误磨损数据库对象件未保存，无法修改表，如果没有群集主键，则无法创建Xml索引.请帮助

hello friend I have downloaded a database from code plex site to my local machine in sql 2008 & I change the index of one attribute & tries to save that database but i got one error message box "error wear encountered during save process some database object ware not saved unable to modify table ,Cannot create Xml index without a clustered primary key.please help

推荐答案

更改定义的主索引会产生此错误. ，从xml数据类型派生的计算列可以被索引为键或包含的非键列，只要该计算列数据类型允许作为索引键列或非键列即可.您不能在计算的xml列上创建主XML索引最好恢复删除的索引并按原样运行.

Changing the defined primary index creates this error. By default, computed columns derived from xml data types can be indexed either as a key or included nonkey column as long as the computed column data type is allowable as an index key column or nonkey column. You cannot create a primary XML index on a computed xml column. Itz better to recover the dropped index and run as it is.

这篇关于更改为sql数据库无法保存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！