chang to sql database does not get save

Question

1.00/5 (2 votes)

See more:

, +

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

Posted 28-Aug-11 7:14am

maheshpardeshi

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2011-08-28T18:10:00

Solution 1

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.

Posted 28-Aug-11 18:10pm

Ganesan Senthilvel

Comments

maheshpardeshi 29-Aug-11 1:42am

but I want to remove index & check the performance & then I want to apply index to another attribute.I have also try to change the "prevent changing table which re create the table" option by disabling it but got same error.