Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?

Answer Posted / kirubaharan

Unable to create index 'PK'.
Cannot define PRIMARY KEY constraint on Computed column in
table.
Could not create constraint. See previous errors.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain system scalar functions?

741


how would you troubleshoot blocking? : Sql server database administration

706


What is not null constraint?

810


What is update locks?

654


Explain an incremental backup?

747






what exactly sql injuction.how to overcome.....

2229


What is auditing in sql server?

675


How will you hide an attribute? : sql server analysis services, ssas

704


What is the purpose of self join?

663


Do you know sql server 2008 introduces automatic auditing?

680


What are different types of raid levels?

735


Name few of the dcl commands in sql?

710


What is 1nf normalization form?

734


Does sql server 2000 clustering support load balancing?

730


What does executeupdate return?

691