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

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

611


What are null values in ms sql server?

558


How to disable stored procedure sql server?

957


What do you understand by coalesce in sql server?

493


What are the restrictions that views have to follow?

555






Call by value and call by reference in procedure and function, with NOCOPY.

831


What is sql server database?

498


is there a column to which a default can't be bound? : Sql server database administration

533


explain how to create a new schema in a database? : Sql server database administration

577


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

554


which table keeps the locking information? : Sql server administration

517


What are the five characteristics of good data?

514


What is CTE in SQL

538


What is database architecture? : SQL Server Architecture

547


How to provide values to user defined function parameters?

553