Answer / kirubaharan

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

Answer / ricky

in sql server 2000 we can create the uniqe and primary key
constraint in computeted coloumn.....but in sql server 2005
we can not create the uniqe and primery constraints in
computed coloumn.

Answer / uma lakshman

Because SQL Server 2000 supports indexes on computed
columns, you can create UNIQUE and PRIMARY KEY constraints
on computed columns

How to create Clustered Primary Key to table?

2 Answers  

---

How do you persist objects, permissions in tempdb

1 Answers  

---

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

---

What is recompile sql server?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---

---

What is the difference between char and varchar2 datatype in sql?

0 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---

what is the purpose of creating view is sql server 2000

13 Answers   Wipro,

---

What is a NOLOCK?

3 Answers   NA,

---

Explain a checkpoint?

0 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---