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

What is data compression? : sql server database administration

0 Answers  

---

Does an index slow down updates on indexed columns?

0 Answers  

---

Write a sql query to display the current date?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

What is the difference between functions and stored procedures?

0 Answers   Accenture,

---

---

What are Row versions of DataRow?

0 Answers  

---

What is use of dbcc commands?

0 Answers  

---

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

---

What is meant by dirty read?

0 Answers  

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

What is bcp? When does it used?

0 Answers  

---