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

Describe the functionalities that views support.

0 Answers  

---

What are the advantages of the mirroring?

0 Answers  

---

What is the recovery model?

0 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

---

what is DTS what are tasks available

1 Answers   Wipro,

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---